| DB Refresh- IMPORT [message #185486] |
Wed, 02 August 2006 00:17  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
Hi,I need a help .Please see the following scenario .
My prod has following schema
Sys
System
ADMINUSR(5000 Objects)
Now i want to refresh test DB using an export dump.Can someone tell me best methord to do that ?Should i drop schema/Object or need to go for a Full refresh .Please lets discuss on this .
Rajiv
|
|
|
|
| Re: DB Refresh- IMPORT [message #185518 is a reply to message #185486] |
Wed, 02 August 2006 02:10  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Export ADMINUSR user from the production database and import it into your test database (make sure you have created this user in the test database before import).
PROD> EXP adminusr/password@prod_db FILE=adminusr.dmp
TEST> IMP adminusr/password@test_db FILE=adminusr.dmp
[Updated on: Wed, 02 August 2006 02:11] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
