From: Miller, Dave (Dave.Miller@BHS.ORG)
Date: Tue Sep 10 2002 - 15:06:49 EDT
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