copy schema
455621Aug 4 2006 — edited Aug 4 2006Hi 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.