Re: Help using IMP/EXP utility

Uchakra <uchakra_at_aol.com> schreef in berichtnieuws 20010720190331.00228.00000367_at_ng-mn1.aol.com...
> 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

This is going to fail if object_owner has unlimited tablespace privilege

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 21 2001 - 00:45:52 CDT