RE: Craete database around existing tablespace

I totally agree... just copying the datafiles does NOT move a tablespace... if you are running Oracle8 you could have used the transportable tablespace functionality to move the tablespace.

however, at this point, I truly hope that that database either had really good backups, or was a test database. Because if not, you have just destroyed your production database.... with no hope of recovering that data.

I truly would suggest a class in Oracle database administration, or reading any of the many Oracle books out there, or at the very least, reading the Oracle manuals.

and if that was indeed a production database, you might consider updating your resume.

>From: Philip West <P.West_at_g-icap.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Craete database around existing tablespace
>Date: Tue, 08 Aug 2000 02:37:08 -0800
>
>YOU CANNOT DO THIS!
>
>All you have done is to get the new database to use the o/s file from the
>old tablespace. Oracle has reinitialised this datafile and it no longer
>holds any data.
>
>You cannot transfer data in this way.
>
>I apologise if this sounds rude but you seem to lack an understanding of
>the
>basic concepts of oracle databases. Before moving forward I would suggest
>that you read material on database structures, database creation and backup
>recovery. If you have a friendly dba nearby get her/him to explain what
>you
>have done and why it will not work.
>
>In this example you would need to export the data from the original
>database
>and import it into the new database. You cannot export by tablespace so
>you
>would need to export the individual objects in the tablespace. If all
>objects in the tablespace are owned by a single oracle user and that user
>does not have objects elsewhere then you could export that user and import
>it into the new database.
>
>
>
>Phil West
>Unix Sys Admin and Oracle Financials DBA
>+44 (0) 20 7623 5222 x5221
>
>-----Original Message-----
>Sent: 08 August 2000 11:00
>To: Multiple recipients of list ORACLE-L
>
>
>
>Good morning
>
>I have decided to move a tablespace from database ORCL to it's own
>database.
>
>I have created the new database, but getting the "old" tablespace into this
>database is a bit of a problem.
>
>The datafiles (4) have been copied to the correct filesystem destination.
>
>I have used
>"CREATE TABLESPACE "MINKEY"
>DATAFILE '/merc1/IMAGE/mindkey01.dbf' REUSE;" - no problem.
>But there are 3 more datafiles that are part of this tablespace. How to I
>get them to be recognised by the tablespace?
>
>Any advice would be greatly appreciated
>
>Thanks
>Karen Turnbull
>This message and any attachments may be confidential and may also be
>privileged or otherwise protected from disclosure. They are sent for the
>attention of the named addressee(s) only. If you are not the named
>addressee(s) please notify the sender immediately and destroy this message.
>In this case, you should not copy or distribute this message or
>attachments,
>use it for any purpose or disclose its contents to any other person.
>Opinions, conclusions and other information in this message that do not
>relate to the official business of my firm/company shall be understood as
>neither given nor endorsed by it.
>
>
>
>*******************************************************************************
>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.
>*******************************************************************************