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.
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 w
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.
Pleas
e try to do the action's part from the help.
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
&g
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
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 (may
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 shoul
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
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
To
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
19, 2001 1: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
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 li
12 matches
Mail list logo
