Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Craete database around existing tablespace
ALTER TABLESPACE"xxxx" ADD DATAFILE 'xx/xx/xx.dbf' REUSE
>>> KTurnbull_at_Billiton.co.za 08/08/00 05:59AM >>>
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=20
"CREATE TABLESPACE "MINKEY"=20
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.
Received on Tue Aug 08 2000 - 08:48:55 CDT