Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Craete database around existing tablespace

RE: Craete database around existing tablespace

From: Jäck Stephan <Jaeck.Stephan_at_REAL.DE>
Date: Tue, 8 Aug 2000 14:13:52 +0200
Message-Id: <10583.114054@fatcity.com>


Hello Karen and Philip,  

depending on your needs in can be useful, to keep an existing tablespace or more in a new database.  

To do this you can clone the database and drop then the unneeded objects. Correct is, that you can't create a new database and then "append" a tablespace from an alreeady existing database and you can clone only within the same OS.  

Stephan

-----Original Message-----

From: Philip West [mailto:P.West_at_g-icap.com] Sent: Tuesday, August 08, 2000 12:37 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Craete database around existing tablespace

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

From: Turnbull, Karen (BSA) [mailto:KTurnbull_at_Billiton.co.za] Sent: 08 August 2000 11:00
To: Multiple recipients of list ORACLE-L Subject: Craete database around existing tablespace

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 Received on Tue Aug 08 2000 - 07:13:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US