Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

copy schema

455621Aug 4 2006 — edited Aug 4 2006
Hi All,

I have a dev server and production server. each server has oracle database installed with its own schema. both schemas are called RC. what i need to do is to destroy the schema on dev and copy the schema from production to dev so that both schemas will be exactly same(including ddl, objects...). i logged into dev and created a dblink to production.

what i think is;
1. destroy the schema in dev by 'drop user rc cascade;'
2. create a blank schema first before copying? how can i make the blank schema same as the production, such as datafile and space?
3. using import and export schema? if i run export command on dev to export the production. the dmp file will be on dev, right? when i import, only dba on dev can import the file exported by dba on production? when i export the file, i am not the dba on production server, right?
4. is there another way to copy schema other than import and export?

i am new on this, really don't have an idea.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2006
Added on Aug 4 2006
1 comment
189 views