Importing & Exporting Data [message #15906] |
Sun, 31 October 2004 13:43 |
TL
Messages: 1 Registered: October 2004
|
Junior Member |
|
|
Hi Guys
I currently export the data from my database everynight using the EXPORT utility. I carry out the export via 'user name' to keep the file sizes small. This is an example of the syntax I use to perform the export:
SET ORACLE_SID=sidname
EXP user/pwd FILE=D:Dumpsidname_user.dmp LOG=D:Dumpsidname_user.log
I then use this export file to populate other databases. I do this by creating an index file first, then reading in the data and finally creating the index's. The syntax I use is as follows:
--Create the index file script.
SET ORACLE_SID=sidname
IMP user/pwd FILE=D:DUMPsidname_user.DMP FULL=Y INDEXFILE=D:sidnameSTANDARD_LOADCr_sidname_Idx.SQL
--Read in the data.
SET ORACLE_SID=sidname
IMP user/pwd FILE=D:DUMPsidname_user.DMP LOG=IMP_SIDNAME_USER_DATA.LOG FROMUSER=user TOUSER=user INDEXES=N IGNORE=Y
--Create the indexes
SET ORACLE_SID=sidname
SQLPLUS user/pwd @D:sidnameSTANDARD_LOADCr_sidname_Idx.SQL
My problem is...
When I am finally creating the indexes, I get prompted to enter the username and password for the user. Is there anyway I can prevent this form happening?
|
|
|