oracle db

From: justin.bleistein@SUNGARD.COM
Date: Tue Sep 10 2002 - 12:34:37 EDT

Next message: Adams Kevin J: "Re: nmon - topas"
Previous message: Vesna Vranesic: "DCE & /usr/bin/show.cfg"
Next in thread: Miller, Dave: "Re: oracle db"
Maybe reply: Miller, Dave: "Re: oracle db"
Maybe reply: justin.bleistein@SUNGARD.COM: "Re: oracle db"
Maybe reply: Gene Sais: "Re: oracle db"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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

Next message: Adams Kevin J: "Re: nmon - topas"
Previous message: Vesna Vranesic: "DCE & /usr/bin/show.cfg"
Next in thread: Miller, Dave: "Re: oracle db"
Maybe reply: Miller, Dave: "Re: oracle db"
Maybe reply: justin.bleistein@SUNGARD.COM: "Re: oracle db"
Maybe reply: Gene Sais: "Re: oracle db"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:11 EDT