Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP-00003: ORACLE error 1658 encountered

summeeJan 13 2014 — edited Jan 13 2014

Hi Guys

I am trying to import dump file created using "import" utility.

But I am getting this error :

IMP-00003: ORACLE error 1658 encountered

ORA-01658: unable to create INITIAL extent for segment in tablespace original_users_tablespace_name

IMP-00017: following statement failed with ORACLE error 1658:

Here I think some tables are getting imported on tablespace of original dumps user rather than user for which I am running import.

How to avoid importing on dumps original users tablespace while importing on new user?

Please Guide.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2014

Added on Jan 13 2014

#database-key-features, #export-import-sql-loader-external-tables

9 comments

12,723 views