| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Craete database around existing tablespace
Absolutely,
My answer was not complete without that. Of course you can use the create controlfile to clone the database and then prune that which you do not need.
Phil West
Unix Sys Admin and Oracle Financials DBA
+44 (0) 20 7623 5222 x5221
-----Original Message-----
From: J=E4ck Stephan [mailto:Jaeck.Stephan_at_REAL.DE]
Sent: 08 August 2000 14:22
To: Multiple recipients of list ORACLE-L
Subject: RE: Craete database around existing tablespace
Hello Karen and Philip,
=20
depending on your needs in can be useful, to keep an existing tablespace or
more in a new database.
=20
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.
=20
Stephan
-----Original Message-----
Sent: Tuesday, August 08, 2000 12:37 PM
To: Multiple recipients of list ORACLE-L
YOU CANNOT DO THIS!
=20
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.
=20
You cannot transfer data in this way.
=20
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.
=20
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.
=20
=20
Phil West=20
Unix Sys Admin and Oracle Financials DBA=20
+44 (0) 20 7623 5222 x5221=20
-----Original Message-----
Sent: 08 August 2000 11:00
To: Multiple recipients of list ORACLE-L
Good morning=20
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.=20
The datafiles (4) have been copied to the correct filesystem destination.=
I
have used=20
"CREATE TABLESPACE "MINKEY"=20
DATAFILE '/merc1/IMAGE/mindkey01.dbf' REUSE;" - no problem.=20
But there are 3 more datafiles that are part of this tablespace. How to I
get them to be recognised by the tablespace?=20
Any advice would be greatly appreciated=20
Thanks=20
Karen Turnbull=20
--=20
Author: =3D?ISO-8859-1?Q?J=3DE4ck_Stephan?=3D
INET: Jaeck.Stephan_at_REAL.DE
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 Inter= net e-mail by anyone else is unauthorised and any disclosure, copying, dist= ribution or any action taken or omitted to be taken in reliance on it, is p=rohibited and may be unlawful.=20
When addressed to our clients any opinions or advice contained in this Int= ernet e-mail are subject to the terms and conditions expressed in any appli= cable 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 exce= pt where they are stated to be the views of Garban Intercapital plc. Received on Tue Aug 08 2000 - 07:58:09 CDT
 |
 |