Home » RDBMS Server » Server Utilities » DB Refresh- IMPORT
DB Refresh- IMPORT [message #185486] Wed, 02 August 2006 00:17 Go to next message
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
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 .

Re: DB Refresh- IMPORT [message #185518 is a reply to message #185486] Wed, 02 August 2006 02:10 Go to previous message
Messages: 20847
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

Previous Topic: SQLLDR Direct=true
Next Topic: problem with sql loader
Goto Forum:

Current Time: Mon Oct 24 02:18:19 CDT 2016

Total time taken to generate the page: 0.09723 seconds