Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> imp and target tablespace
A guy from an external company came here this morning to install the new
version of their software. He asked me to create a new user and a new
tablespace for the new app version and I did it. Then he asked me to
load a dump file containings all the app database objects. I did it but
I noticed that all objects were created in the tablespace USERS. I asked
him if he had an object creation script instead of a dump file and he
said no. So I had to extract the object creation script using imp,
replace all occourences of tablespace "USERS" with the name of the brand
new app tablespace and run the script vith SQL*Plus (there were no
meaningful data in the dump file; he just needed the empty objects).
I was a very awful job, so I'm wondering if there is an easier way to force imp to import objects in a different tablespace than the one buried into the dump file. In my case, the preferred target tablespace was also the user's default tablespace.
-- Cris Otto Partz (spamto:cris119_at_operamail.com) Microsoft? Is that some kind of toilet paper?Received on Fri May 30 2003 - 05:58:28 CDT