It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,115
×4,321
×1,698

question asked: Dec 14 '12, 3:30 p.m.
question was seen: 5,098 times
last updated: May 25 '13, 4:28 p.m.

Related questions

oracle configuration in windows

0
nityananda sahu (1●1●11●11) | asked Dec 14 '12, 3:30 p.m.
retagged May 25 '13, 4:28 p.m. by Scott Rich (571●3●6) 
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.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Alex Fitzpatrick (558●3●8●16) | answered Dec 14 '12, 3:55 p.m.
JAZZ DEVELOPER
edited Dec 14 '12, 4:31 p.m. 
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.


Your answer

Register or 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.