Re: Quick transportable tablespace question

Chuck wrote:
> Oracle 9.2.0.8
>
> Does it matter at all when the export of the meta data is done when
> creating a transportable tablespace? Assume nothing in the physical
> structure of the tablespace changes (i.e. no additional datafiles or no
> file resizing, etc.). For example can I do the export one day, and make
> the datafile copies the next day?
>
> I guess what it comes down to is this - is there any scn info in that
> meta data?

On occasion, I have used an older metadata file when I knew that the only thing that changed in the tablespace was the rows of data in the tables. So this may just work for you. You should test it out for your specific case.

If you do your export one day while the tablespace is READ ONLY, and you   make the datafile copies the next day and the tablespace has been READ ONLY the whole time, then there is nothing to worry about.

That being said, any reason why you can't make the metadata dump file anew? It only takes a minute....

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com