Re: Help using IMP/EXP utility

Withpout knowing what exactly is your
scenario, it's difficult to give a specific answer. However, I would give an example and see if you can use it .

Lets's assume the owner of the objects
is 'object_owner'

Let's say old tablespace is ot_space

Let's say the new tablespace is nt_space

Step 1) do the exp

step 2) alter user object_owwner
 quota 0k on system quota 0k on ot_space

step 3) alter user object_ownwer default tablespace nt_space quota unlimited
on nt_space

You will do steps 2 and step 3 as a DBA

4) Now get drop the objects
  you exported

5) Do the import using the exp dump file

You might consider the use of
transportable tablespace also.
Look at the doc for the systax on
how to setup and do the transport Received on Fri Jul 20 2001 - 18:03:31 CDT