Hi All,
I have a task on hand for which I need some suggestions
We are upgrading our test environemts to make them as close as
possible to our live environments at least in terms of the meta data
as we still do not have resouces to completely match them in terms of
metadata and the data.
So i am thinking to take an export of the Prodcutin database ( meta
data only ) to have the definations on objects exported. My
understanding is that it will export every thing other than the table
data ( i.e. schemas, tablespace,table defination grants ,etc). but my
conern is that when i import
1- do i need to create the tablespaces befor hand
2- if not the i do not have all the path available in test environment
as i have in prod ( storage limitation)
can some if possible explain how to handle that?
thanks in advance
Received on Mon Nov 05 2007 - 08:48:42 CST
