From: justin.bleistein@SUNGARD.COM
Date: Tue Sep 10 2002 - 15:16:49 EDT
It was a permission problem the tablespace works now thanks for your
suggestion YOU ARE THE MAN!!:
SQL> create tablespace payroll datafile
'/database/oradata/justindb/dragon-payro
ll.dbf' size 4M;
Tablespace created.
SQL>
--Justin
"Miller, Dave"
<Dave.Miller@BHS. To: aix-l@Princeton.EDU
ORG> cc:
Sent by: IBM AIX Subject: Re: oracle db
Discussion List
<aix-l@Princeton.
EDU>
09/10/2002 03:06
PM
Please respond to
IBM AIX
Discussion List
check the ownership and permissions of /home/oracle and make sure the user
you started oracle as the appropiate access to it.
-----Original Message-----
From: justin.bleistein@SUNGARD.COM [mailto:justin.bleistein@SUNGARD.COM]
Sent: Tuesday, September 10, 2002 12:35 PM
To: aix-l@Princeton.EDU
Subject: oracle db
Ok Oracle Buffs,
I'm just learning oracle db and I have the oracle code which comes
with AIX4.3 installed on my h80. I get the following error when trying to
create the following tablespace:
SQL> create tablespace payroll datafile '/home/oracle/testdatafile' size
3M;
create tablespace payroll datafile '/home/oracle/testdatafile' size 3M
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/home/oracle/testdatafile'
Does anyone know how to correct this? It would be appreciated thanks!.
--Justin Richard Bleistein
Sungard
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:12 EDT