Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01119: error in creating database file

Kashif ManzoorSep 23 2008 — edited Sep 23 2008
Hi,

I am trying to run scripts adcrtbsp.sql but it is giving following error.

adcrtbsp.sql script contains:

--------------------------
CREATE TABLESPACE
APPS_TS_TX_DATA
DATAFILE '?/dbf/transaction_table.dbf'
SIZE 1000 M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
SEGMENT SPACE MANAGEMENT AUTO ;

ALTER TABLESPACE
APPS_TS_TX_DATA
add DATAFILE
'?/dbf/transaction_table_2.dbf'
SIZE 1000 M;

ALTER TABLESPACE
APPS_TS_TX_DATA
add DATAFILE
'?/dbf/transaction_table_3.dbf'
SIZE 1000 M;

CREATE TABLESPACE
APPS_TS_TX_IDX
DATAFILE '?/dbf/transaction_index.dbf'
SIZE 1000 M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128 K
SEGMENT SPACE MANAGEMENT AUTO ;

ALTER TABLESPACE
APPS_TS_TX_IDX
add DATAFILE
'?/dbf/transaction_index_2.dbf'
SIZE 1000 M;
------------------------------

sqlplus system/pwd @adcrtbsp.sql

--------------------------------------------------------------------------------
CREATE TABLESPACE
*
ERROR at line 1:
ORA-01119: error in creating database file 'f:/oracle/dbf/transaction_table.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
--------------------------------------------------------------------------------
Anybody can guide ??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2008
Added on Sep 23 2008
2 comments
28,762 views