RE: Working, middle of night

i would say that most probably the tablespace is SYSTEM as the datafile is system01.dbf.

this is fairly typical of oracle datafile naming standards.

hth
karl

• Linda Hagedorn <Linda_at_pets.com> wrote:
  > Richard,
  >
  > Is there a way to determine the tablespace name without the benefit
  > of using
  > SVRMGRL or SQLPLUS? I cannot query dba_data_files with the database
  > in it's
  > current state, that is, pointing to all files which are in the wrong
  > location; Missing for all intensive purposes. Without the tablespace
  > name,
  > I cannot execute the ALTER TABLESPACE command.
  >
  > Any suggestion is appreciated.
  >
  > Thanks, Linda
  >
  > -----Original Message-----
  > Sent: Tuesday, June 06, 2000 3:25 AM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Linda,
  >
  > it's daylight here (Holland)...so there's always someone around to
  > help.
  >
  > I think you should try to rename the datafiles from within Oracle,
  > not Unix:
  > ALTER TABLESPACE xxxx RENAME DATAFILE
  > '/oradata/PETS/data1/system01.dbf'
  > TO ' /opt/oracle/app/oracle/oradata/PETS/data/system01.dbf';
  >
  > First, startup the database in MOUNT mode.
  >
  > Regards, Richard Klavers
  >
  > > ----------
  > > Van: Linda Hagedorn[SMTP:Linda_at_pets.com]
  > > Antwoord naar: ORACLE-L_at_fatcity.com
  > > Verzonden: dinsdag 6 juni 2000 10:49
  > > Aan: Multiple recipients of list ORACLE-L
  > > Onderwerp: Working, middle of night
  > >
  > > Hope someone's around tonight...
  > >
  > > I have some datasets in the 'wrong' place, and the database is
  > failing to
  > > open with this error: Database mounted.
  > > ORA-01157: cannot identify data file 1 - file not found
  > > ORA-01110: data file 1: '/oradata/PETS/data1/system01.dbf'
  > >
  > > I want to create soft links from the recorded name:
  > > /oradata/PETS/data1/system01.dbf, to the location where the dataset
  > > actually
  > > resides: /opt/oracle/app/oracle/oradata/PETS/data/system01.dbf
  > >
  > > I don't have root, and am reluctant to move the datasets around.
  > >
  > > Does someone know the syntax to create a Unix soft-link?
  > >
  > > Thanks very much. Linda
  > >
  > > PS. The source of the problem is no mystery. In an effort to make
  > space
  > > in
  > > an emergency, files were moved (not by me) to different
  > directories. This
  > > has been done to a significant number of the files. While this is
  > not
  > > production, it is QA/Dev, and I'm anxious to put the house back in
  > order.
  > > This is a temporary situation, and meetings are underway to work
  > out the
  > > space issues. In the mean time, I need to get this database back
  > on-line,
  > > and the Unix soft-link is, I think, the least painful way to get
  > the
  > > system
  > > up. I'm looking at 18 hours processing, so if you know the
  > soft-link
  > > syntax, I'd appreciate knowing it. Thanks.
  > >
  > >
  > > --
  > > Author: Linda Hagedorn
  > > INET: Linda_at_pets.com
  > >
  > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > > San Diego, California -- Public Internet access / Mailing
  > Lists
  > >
  > --------------------------------------------------------------------
  > > To REMOVE yourself from this mailing list, send an E-Mail message
  > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > > the message BODY, include a line containing: UNSUB ORACLE-L
  > > (or the name of mailing list you want to be removed from). You may
  > > also send the HELP command for other information (like
  > subscribing).
  > >
  > --
  > Author: Klavers, Richard
  > INET: R.Klavers_at_arbeidsbureau.nl
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  > --
  > Author: Linda Hagedorn
  > INET: Linda_at_pets.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).