Re: from existing schema to new schema

Re: from existing schema to new schema

 

  

You can use a data pump exp/imp using expdp's parameter SCHEMAS and
impdp's parameter REMAP_SCHEMA or the good old exp/ikmp process using
exp's parameter OWNER and the imp's parameters FROMUSER & TOUSER.

Israel.

Luis Cardenas escribió:

>Who knows who in 10g can I copy an existing schema to a new one within
>
>the same db, new tablespace though using grid control...
>
>
>
>
>
>
>
>thanks,
>
>
>
>Luis
>
>
>
>
>
>
>
>
>
>-----------------------------------------
>
>This e-mail is sent on behalf of Trader Media Group Limited,
>registered office: Unit 6, Thatcham Business Village, Colthrop
>Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
>4768840). This email and any files transmitted with it are
>confidential and intended solely for the use of the individual or
>entity to whom they are addressed. If you have received this email
>in error please notify the sender. This email message has been
>swept for the presence of computer viruses. www.ciphertrust.com
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>

Oracle LazyDBA home page