Home » RDBMS Server » Server Utilities » Auto import required...
Auto import required... [message #72892] Thu, 04 December 2003 05:26 Go to next message
shahzad
Messages: 17
Registered: February 2002
Junior Member
dear sir,
would you like to tell me the auto import of the database, without any warnings...
i have batch file of export which can take auto backup of database...
pls help me....

thx
Re: Auto import required... [message #72893 is a reply to message #72892] Thu, 04 December 2003 05:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
just the other way..
-- first truncate or drop all the objects in target schema
-- 
imp dbaUser/password fromuser=original_user_in_source touser=target_user_in_target file=somefile.dmp ignore=y

Re: Auto import required... [message #72897 is a reply to message #72892] Fri, 05 December 2003 04:30 Go to previous message
naveen dutt
Messages: 8
Registered: December 2003
Junior Member
Hi,
If your oracle on windows then put the batch file on secdudling and set the time at which it will run automaticaly.

Naveen dutt
Previous Topic: I cant start listener
Next Topic: import query help
Goto Forum:
  


Current Time: Wed Jun 26 12:59:30 CDT 2024