Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: imp and target tablespace
On Fri, 30 May 2003 12:58:28 +0200, Cris Otto Partz wrote:
> 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.
During Import if the tablespace "USERS" did not exist then it would have put the objects in the default tablespace . you could have dropped users tablespace if did not have any prod objects or objects that could have recreated . not a good option . Another option may be is to rename the tablespace , but oracle does not provide this option . somebody will surely have an explanation for this . Received on Fri May 30 2003 - 22:30:47 CDT