Message-Id: <10520.107819@fatcity.com> From: karl craven Date: Tue, 6 Jun 2000 04:09:40 -0700 (PDT) Subject: 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 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@pets.com] > > Antwoord naar: ORACLE-L@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@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@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@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@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@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@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).