Home » RDBMS Server » Server Administration » Problem with AIX permissions creating a datafile
Problem with AIX permissions creating a datafile [message #371115] Wed, 30 August 2000 13:28
Paul
Messages: 164
Registered: April 1999
Senior Member
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@my_sid @file.sql

Please help !
Thanks,
Paul
Previous Topic: can Sequence be generated using JUST ome select statement...
Next Topic: newbie who needs urgent help
Goto Forum:
  


Current Time: Fri Oct 30 03:31:34 CDT 2020