RE: Working, middle of night

Tablespace names can be found in mount, try v$tablespace. It can be joined to v$datafile using ts#. I find this helpful when determining whether I am in a recovery situation where the instance must remain in mount versus taking the file offline and doing an online recovery after the database is open.

HTH,
James

-----Original Message-----
From: Philip West [mailto:P.West_at_g-icap.com] Sent: Tuesday, June 06, 2000 6:35 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Working, middle of night

the command is 'alter database datafile .............' and not 'alter tablespace datafile ............'

you do not need to know your tablespace names.

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

[ all opinions, unless otherwise stated, are personal and subject to change without reason or warning ! ]

-----Original Message-----
Sent: Tuesday, June 06, 2000 12:50 PM
To: Multiple recipients of list ORACLE-L

Linda,

that is somewhat difficult...have you ever done a full export? The exportfile contains the tablespace names. Do you have the create scripts of the database? Do they contain the tablespace names?
Otherwise I can't think of a way to find out the tablespace names. The contolfile only contains the datafile names. It is very important to make lists of your database configuration when it is working, so you can re-create it again.
Maybe someone else got an idea?

Regards, Richard Klavers

> ----------
> Van: Linda Hagedorn[SMTP:Linda_at_pets.com]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: dinsdag 6 juni 2000 13:21
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: Working, middle of night
>
> 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).
>

-- 
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).


****************************************************************************
***
The information in this Internet e-mail is confidential and may be legally
privileged.  It is intended solely for the addressee.  Access to this
Internet e-mail by anyone else is unauthorised and any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this
Internet e-mail are subject to the terms and conditions expressed in any
applicable documentation or market practices governing the relationship
between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender
except where they are stated to be the views of Garban Intercapital plc.
****************************************************************************
***
-- 
Author: Philip West
  INET: P.West_at_g-icap.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