DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: problem creating tablespace

  1. 04-24-2001, 04:56 PM #1
    oracleman
    oracleman is offline Junior Member
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    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
    Reply With Quote Reply With Quote
  2. 04-24-2001, 04:59 PM #2
    DBAtrix
    DBAtrix is offline Member
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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.
    Reply With Quote Reply With Quote
  3. 04-24-2001, 05:10 PM #3
    oracleman
    oracleman is offline Junior Member
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    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.
    Reply With Quote Reply With Quote
  4. 04-24-2001, 05:12 PM #4
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Command to delete a file in UNIX: rm (file_name)
    -
    example: rm /u01/ora01/mydata_2001.dbf
    Reply With Quote Reply With Quote
  5. 04-24-2001, 05:15 PM #5
    DBAtrix
    DBAtrix is offline Member
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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.
    Reply With Quote Reply With Quote
  6. 04-24-2001, 06:02 PM #6
    oracleman
    oracleman is offline Junior Member
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65
    thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width