Home » RDBMS Server » Backup & Recovery » export script (oracle 8i, hp ux)
export script [message #358409] Tue, 11 November 2008 02:55 Go to next message
jayarago
Messages: 12
Registered: December 2006
Location: Chennai
Junior Member
Hi,

I am working in oracle 8i. I am having two databases namely one and two. i need to take the export backup from database one and then to shutdown the database two then startup then to drop the schema <schema_name> and create the schema then to import the export dump in Database two.


i need a script that is to be run in database two. my version is 8.1.4

Rgds
Re: export script [message #358412 is a reply to message #358409] Tue, 11 November 2008 03:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shutdown
startup
drop user ... cascade;
host imp ...

Regards
Michel
Re: export script [message #358414 is a reply to message #358412] Tue, 11 November 2008 03:04 Go to previous messageGo to next message
jayarago
Messages: 12
Registered: December 2006
Location: Chennai
Junior Member
Hi,

if i run the below mentioned script manually it's working fine.

/system/app/oracle/product/8.1.7/bin/svrmgrl << EOF
connect internal
spool /appl/oracle/bckp/test.txt
@/appl/oracle/bckp/test.sql
spool off
EOF
/system/app/oracle/product/8.1.7/bin/imp system/manager file=/appl/oracle/bckp/schema_exp.dmp log=/appl_test/oracle/bckp/exp.log fromuser=one touser=one;

TEST.SQL File

drop user one cascade;
create user one identified by one
default tablespace test1
temporary tablespace temp
quota unlimited on test1;
grant connect , create session to one;

but if i use cronjob its throwing the error....

drop user one cascade
*
Error while trying to retrieve text for error ORA-03114
create user one identified by one
*

Kondly provide me a script that is to be run in cron job...

Re: export script [message #358416 is a reply to message #358414] Tue, 11 November 2008 03:08 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you set ORACLE_HOME and ORACLE_SID and so on in your script?

Regards
Michel
Previous Topic: Loss of Table
Next Topic: restore time
Goto Forum:
  


Current Time: Fri Dec 09 09:55:09 CST 2016

Total time taken to generate the page: 0.12735 seconds