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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Missing tablespace using imp

747325Aug 9 2012 — edited Aug 10 2012

I am attempting to copy an entire schema from one 11gR2 instance to another. The users are not the same, for example olduser defaults to oldtablespace in the old database, newuser defaults to newtablespace in the new database. The default tablespace for the two users is different between the two databases. The user has about 1300 tables. When I do the import all of the are imported fine except for 6 or 8 tables. On those I get an error that it couldn't create the table because oldtablespace doesn't exist. I've done this over and over with the same tables not getting created.

I tried creating a old_tablespace in the new database but when I do the import all of the tables get imported to that tablespace instead of new_tablespace.

I'm using this form for the command: imp newuser/passwd@db file=dumpfile fromuser=olduser touser=newuser ignore=y

I have worked on this all day without success and would very much appreciate someone telling me what I am doing wrong and how to get around those failed tables.

Randy