-
I tried to create a tablespace. Unfortunaley, I did not have enough space so I received this error below
create tablespace DATA_2001
*
ERROR at line 1:
ORA-19502: write error on file
"/u01/ora01/mydata_2001.dbf", blockno 385601
(blocksize=4096)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 262144
ORA-19502: write error on file
"/u01/ora01/mydata_2001.dbf", blockno 386177
(blocksize=4096)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 262144
Now I have a lot of space. So Idecided to go back to create the same tablespace again. But now I am getting the message that the file already exists.
create tablespace DATA_2001
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u01/ora01/mydata_2001.dbf'
ORA-27038: skgfrcre: file exists
Any help will be apprecitaed.
OS/AIX
DATABASE VERSION:8.1.5.0.0
-
Did you delete the file from the aborted attempt to create the tablespace? oracle will not remove the leftovers. in general, oracle does not manage files from the OS when you do any database drops, deletes or renames.
d.
-
okay. So I'm thinking that I have to delete the file from the OS level. Can you give me the command to do this in unix assuming the datafile name is "/u01/ora01/mydata_2001.dbf''.
I'm new to unix so I want to make sure that I am deleting the right stuff. I will aprreciate an example.
I'm running AIX.
-
Command to delete a file in UNIX: rm (file_name)
-
example: rm /u01/ora01/mydata_2001.dbf
-
ahh, did not realize you're a newbie to unix, too. the command is "rm" (obvious, right?). to be really sure, use the -i flag to confirm the name. e.g.
rm -i /u01/ora01/mydata_2001.dbf
git yerself a good unix starter book soon. it will make your life easier.
d.
-
