Home » RDBMS Server » Server Utilities » data import from production to test (Oracle 11.2.0.1, windows 2008 R2)
data import from production to test [message #540874] Thu, 26 January 2012 07:50 Go to next message
patdev
Messages: 53
Registered: August 2008
Member
Hi,

I want to automate the import from production to test.

1) export the production schema
2) import in to test server?

How can i automate that currently i am doing it manually as follow:

1) expdb the production schema
2) kill all connection on the test server to test schema
3) drop test user cascade;
4) recreate user;
5) impdb the production schema to test:

but i want it to automated or scheduled so i dont; have to log in every night!!

Please guide

thanks
Re: data import from production to test [message #540875 is a reply to message #540874] Thu, 26 January 2012 07:53 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Instead of killing all connections to the test database, you can close it and open in RESTRICTED mode
Rest steps are simple
Re: data import from production to test [message #540876 is a reply to message #540875] Thu, 26 January 2012 08:00 Go to previous messageGo to next message
patdev
Messages: 53
Registered: August 2008
Member
i cannot take whole database in restricted mode. eventhoug,

How can i automate the process on windows!
Re: data import from production to test [message #540877 is a reply to message #540876] Thu, 26 January 2012 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have not to recreate the user impdp will do it.

Regards
Michel
Re: data import from production to test [message #540878 is a reply to message #540877] Thu, 26 January 2012 08:14 Go to previous messageGo to next message
patdev
Messages: 53
Registered: August 2008
Member
oh ok, thanks. But how can i automate on windows so don't have to do it manual script execution.
Re: data import from production to test [message #540881 is a reply to message #540878] Thu, 26 January 2012 08:19 Go to previous message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Windows script and scheduler but this is no more an Oracle question.
Post this new question in a Windows forum.

Regards
Michel
Previous Topic: sqlldr - change the load type from "bulk" to "normal" ?
Next Topic: Tracking a Data Pump job
Goto Forum:
  


Current Time: Tue Jul 29 04:26:30 CDT 2014

Total time taken to generate the page: 0.10751 seconds