Where to change Database datafile name and path in datastage
Posted: Wed Feb 04, 2009 3:20 am
Hi All,
The DBA has moved the oracle schema attached to my project to a different file system due to some memory issues. The schema name is the same as the old one but the data file name and path is changed. Now when I am trying to load database table from datastage job, I am getting fatal error as below:
SQL*Loader-951: Error calling once/load initialization
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data1/app/oracle/oradata/smartdc/SMART.dbf'
ORA-27041: unable to open file
The datafile it is pointing to is SMART.dbf, but now the data filename is changed to SMART_NEW.dbf.
I am using Oracle Enterprise stage to connect to database.I want to know where in Datastage can I change the datafile path it is pointing to.
Thnx in adv
The DBA has moved the oracle schema attached to my project to a different file system due to some memory issues. The schema name is the same as the old one but the data file name and path is changed. Now when I am trying to load database table from datastage job, I am getting fatal error as below:
SQL*Loader-951: Error calling once/load initialization
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data1/app/oracle/oradata/smartdc/SMART.dbf'
ORA-27041: unable to open file
The datafile it is pointing to is SMART.dbf, but now the data filename is changed to SMART_NEW.dbf.
I am using Oracle Enterprise stage to connect to database.I want to know where in Datastage can I change the datafile path it is pointing to.
Thnx in adv