Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: imp and target tablespace

Re: imp and target tablespace

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Sat, 31 May 2003 03:30:47 GMT
Message-ID: <pan.2003.05.31.03.31.46.449145@attbi.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US