force import into specific tablespace
Hi,
I have been tasked with importing a client dump into our 9.2.0.8 db. Problem is - it seems that a bunch of the Non-system tables that I am trying to import were originally stored on the System tablespace.
The import user's default tablespace is USERS and that's the only tablespace it has any quota on. Based on a few things I found on Google, this would theoretically force the import to put the above mentioned tables into the USERS tablespace. But no such luck...instead it just throws errors that it can't put them in SYSTEM.
The only solution I have come up with so far is either importing it to a sandbox db, relocating the tables, exporting and then putting it in its final destination..or having the client relocate their tables. At this point, since this file is supposed to be uploaded regularly, the first one is a complete pain and the second one...well...no one wants to push that back unless it has to be done.
I have been tasked with importing a client dump into our 9.2.0.8 db. Problem is - it seems that a bunch of the Non-system tables that I am trying to import were originally stored on the System tablespace.
The import user's default tablespace is USERS and that's the only tablespace it has any quota on. Based on a few things I found on Google, this would theoretically force the import to put the above mentioned tables into the USERS tablespace. But no such luck...instead it just throws errors that it can't put them in SYSTEM.
The only solution I have come up with so far is either importing it to a sandbox db, relocating the tables, exporting and then putting it in its final destination..or having the client relocate their tables. At this point, since this file is supposed to be uploaded regularly, the first one is a complete pain and the second one...well...no one wants to push that back unless it has to be done.
0