|
This is a pretty common procedure, which isn't too
hard to accomplish. So here is a step-by-step guide.
- Export the entire schema from production:
exp userid=system file=user_a.dmp log=user_a.log
owner=a
- FTP the dump file (in BINARY mode) to the
development server.
- Make sure user B exists in your development
instance.
- imp userid=system file=user_a.dmp log=imp.log
fromuser=a touser=b
The only big sticking point is that user B may have a
different default tablespace then user A, if user A
exists. If this is the case, and user B has been
granted the CONNECT role, then user B's tables will be
created in user A's default tablespace. To stop this,
make sure that user B has the correct default
tablespace and make sure that you revoke UNLIMITED
TABLESPACE from user B.
For More Information
|
