Re: SQL dump?
Date: June 14, 2006 03:26AM
For dumping use script like:
loadercli -d mydb -u dba,dba -b exportdata
where exportdata is a configuration file:
CATALOGEXTRACT USER OUTSTREAM FILE '[some path]\mydb_cat'
TABLEEXTRACT USER DATA OUTSTREAM FILE '[some path]\mydb_data' RECORDS
The first line will extract the catalog (i.e. table definitions, etc.) the next command line will extract the data.
Since I usually use sqlstudio to create the tables, I edit the file mydb_cat and load it from the sqlstudio. To load the data use something like:
loadercli -d copy_db -u dba,dba -n 192.168.178.17 -b uploaddata
In this case the data is loaded to a remote db and uploaddata is a command script:
TABLELOAD USER DATA INSTREAM FILE '[some path]\mydb_data' RECORDS
You might change in both command scripts the parameter "USER" (see docs).
In case of "USER" it's important that the user exists on the copy db.
Edited 1 time(s). Last edit at 06/14/2006 03:27AM by S Dierkes.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.