Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

oracle configuration in windows

Hi
i have run this query in oracle sqlplus,but it is not working because it is unable 
to get the path name of dbf file. i m using RTC CLM 3.0
orcle 10g enterprise edition also.
kindly update me

SQL> CREATE BIGFILE TABLESPACE oracle_tbs DATAFILE 'c:\oracle_tbs\oracle_tbs.dbf' SIZE 1G AUTOEXTEND
ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE BIGFILE TABLESPACE oracle_tbs DATAFILE 'D:\oracle_tbs\oracle_tbs.dbf' SIZE 1G AUTOEXTEND ON E
*
ERROR at line 1:
ORA-01119: error in creating database file 'D:\oracle_tbs\oracle_tbs.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

0 votes



One answer

Permanent link
The system cannot find the path specified.
	
	
Oracle is telling you it can't find your file path. Note that you used c:\ for the first create and D:\ for the second one.

Double check your file paths.


0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,125
× 1,700

Question asked: Dec 14 '12, 3:30 p.m.

Question was seen: 5,189 times

Last updated: May 25 '13, 4:28 p.m.

Confirmation Cancel Confirm