Create TableSpace Permissions Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Create TableSpace Permissions Problem

  1. #1
    Join Date
    May 2003
    Location
    Miami, FL
    Posts
    22

    Create TableSpace Permissions Problem

    I'm trying to execute the following on a Linux box w/ Oracle 9i from a Squirrel SQL client:
    Code:
    CREATE TABLESPACE test01
    	DATAFILE '/test01_001.dbf'
    	SIZE 15M REUSE
    EXTENT MANAGEMENT LOCAL
    But I'm getting the following error when I execute:
    Error: java.sql.SQLException: ORA-01119: error in creating database file '/test01_001.dbf'
    ORA-27040: skgfrcre: create error, unable to create file
    Linux Error: 13: Permission denied
    Anyone know what this means?
    Transio - Home | About | Design | Company

  2. #2
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    You don't have 'write' permission to that folder.

  3. #3
    Join Date
    May 2003
    Location
    Miami, FL
    Posts
    22
    Yeah, I figured that out I just wanted to put it in the root folder for testing, then figured out that I wouldn't be able to do that, LOL
    Transio - Home | About | Design | Company

Posting Permissions

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


Click Here to Expand Forum to Full Width