Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Problem with AIX permissions creating a datafile

Problem with AIX permissions creating a datafile

From: <sperepeps_at_hotmail.com>
Date: Wed, 30 Aug 2000 18:07:14 GMT
Message-ID: <8ojifv$ub5$1@nnrp1.deja.com>

Hi All,
I'm a beginner so please forgive me for this stupid question. Running this file.sql with the following contents: CREATE TABLESPACE test
  DATAFILE '/data/test_file' SIZE 30M
  DEFAULT STORAGE (
  INITIAL 100K
  NEXT 100K
  MINEXTENTS 2
  MAXEXTENTS 249)
  offline;

I get the following error:
ORA-01119: error in creating database file '/data/test_file' ORA-07352: sfccf: create error, unable to create file. IBM AIX RISC System/6000 Error: 13: Permission denied

I run the script in this way sqlplus sys_at_my_sid @file.sql

Please help !
Thanks,

            Paul

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 30 2000 - 13:07:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US