Re: Copy user quickly

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Fri, 22 Aug 2003 15:26:17 +0300
Message-ID: <3f460beb_1@news.estpak.ee>

Hi!

If you know how to use transportable tablespaces, you should already know export/import well...

You can exp owner=(youruser) rows=n

and import on another server

imp ignore=y

and it is really easy to select count(*) from user_objects on both servers afterwards and start digging from there.

Cheers,
Tanel.

"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 - 07:26:17 CDT