I tried this but still is not working!!!
See the attachment...
--- satar naghshineh [EMAIL PROTECTED] wrote:
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
Hi List,
I tryed to create the tablespace from svrmgr30
as satar naghshineh told me.
But i still face the same error...
CREATE TABLESPACE PAYROLL
DATAFILE 'C:\PAYROL.ORA' SIZE 10M
SQL /
ERROR at line 1:
ORA-19502: write error on file C:\PAYROL.ORA,
blockno 1 (blocksize=2048)
.
Regards,
Nirmal
-Original Message-
From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Error in creating tablespace
Hi List,
I tryed to create the tablespace from svrmgr30
as satar
Ashraf,
I know that it sounds far fetched but do you have contigous free space to write the 2
K block that Oracle will try to write on the C drive. Do you have any virus
protection turned on that prevents you from writing in the root directory? Try the
same command in a sub directory.
Please
Hello list,
I'm using Personal Oracle8 Database and Win98 Platform
I issued this command from Sqlplus8.0 :
CREATE TABLESPACE PAYROLL
DATAFILE 'C:\PAYROL.ORA' SIZE 10M
SQL /
I am trying to create new tablespace Payroll but I
have got this error!
CREATE TABLESPACE PAYROLL
*
ERROR at
:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Error in creating tablespace
Hello list,
I'm using Personal Oracle8 Database and Win98 Platform
I issued this command from Sqlplus8.0 :
CREATE TABLESPACE PAYROLL
DATAFILE 'C:\PAYROL.ORA' SIZE 10M
SQL /
I am
Is there enough space on C:?
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: ASHRAF SALAYMEH [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 19. September 2001 12:15
An: Multiple recipients of list ORACLE-L
Betreff: Error in creating
Title: RE: Error in creating tablespace
Is there sufficient space on the C: drive. How big is the file that has been created. If it is less than 10M that may be your problem
John
-Original Message-
From: ASHRAF SALAYMEH [mailto:[EMAIL PROTECTED]]
Sent: 19 September 01 11:15
Jared,
Can you check that my email is actually getting through to the list. I
realise this is a bit dumb, cause if you get this then it is...but I can't
actually see any of my mails when and if they hit the list. I used to be
able to but no more... :(
Cheers,
Kev.
hit any user to continue
Title: RE: Error in creating tablespace
Kevin,
I am replying to the list and to you directly, you are getting through to the list. I think there is a way to set up the subscription such that you don't get your own mails.
In any case, you will definitely get one answer. you should get
Salaam Ashraf Jon,
It appears that Oracle has a problem writing to the C
drive to create the datafile on the very first block.
This error is usually the result of a size issue over
4gb for the datafile or a file that has been
autoextended. In your case, it appears it doesn't like
the command
11 matches
Mail list logo