Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error in creating tablespace
Ashraf Jan,
Create a directory within the C drive labled "ORADATA". Then in svrmgr30, login as system, then type:
CREATE TABLESPACE PAYROLL DATAFILE
'C:\ORADATA\PAYROL.ORA' SIZE 10M;
make sure to use the semicolon, not the /. I know it
sounds stupid, but just do it please.
Please let me know what happens. For some reason, Oracle is having a problem writing to the FIRST block, which indicates that something is preventing writes to the root directory.
Regards,
Satar Naghshineh
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: satarnag_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Sep 20 2001 - 18:01:16 CDT