Re: create a new tablespace from a .ora file only

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 28 Nov 2001 01:27:52 -0800
Message-ID: <a8aed4.0111280127.954e6d5@posting.google.com>

snebben_at_cannontech.com (snebben) wrote in message news:<ae25dcb3.0111270932.7a832fb9_at_posting.google.com>...
> To make a long story short...all I have left is the oldtablespace .ora
> file. Now I may be asking a silly question but can I create a new
> instance of this tablespace on a different Oracle server and NOT loose
> the data that was in the tablespace/database?
>
> Thanks,
> Stacey

No Sorry this not possible. Every Database has a Unique ID and that id i s imprinted into each and every datafile. Apart from this there is no Command that will keep the existing file info on creation.

Regards,
Ganesh R Received on Wed Nov 28 2001 - 03:27:52 CST