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