try typing exp at a command prompt and see what it tells you.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"charlie cs" <cs3526(no spam)@yahoo.com> wrote in message
news:b0n1b.23664$N37.21738_at_nwrdny02.gnilink.net...
> We are using 9i.
>
> We have a user that I need to transfer to another database. The user hold
> several huge tables, about 70G total. Exp/imp is not fast enough.
>
> What I did is put the tables and indexes into a tranportable tablespace,
and
> then transport it to the target database. Transport those huge table took
> only 1 hour to finish.
>
> The problem is, how can I make sure all the others has been moved as well,
> like grants, constraints, package????
>
> Is there something like export (owner=scott tables=n)?
>
> Any suggestions?
>
> Thanks
>
>
>
Received on Fri Aug 22 2003 - 06:43:03 CDT
