| import from one db to another [message #131259] |
Fri, 05 August 2005 00:52  |
vgs2005
Messages: 123
Registered: April 2005
|
Senior Member |
|
|
|
we have 2 dbs. One is QA and one is Prod. we would like to copy the data (in all user tables) from Prod to QA. How do I do that? Some of the tables also have blob data.. I don't know much db administration... please help..thanks.
|
|
|
|
| Re: import from one db to another [message #131297 is a reply to message #131259] |
Fri, 05 August 2005 03:48  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
1. you can do an RMAN clone.
2. export prod and import into QA ( if volume of data is small)
3. Do a cold copy clone. SHutdown PROD. copy all files to another location. Bring this new database as QA.
4. use materialized views.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
