| export script [message #358409] |
Tue, 11 November 2008 02:55  |
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 #358414 is a reply to message #358412] |
Tue, 11 November 2008 03:04  |
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...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
