Where will the imported tablespaces end up?
We have two servers: one Netware 5.1
running Oracle 8i and one Win 2003 running Oracle 11g. The 8i is
production; the 11g is new and empty. I need to bring everything over
from 8i to 11g. I am the only developer/administrator here so I don't
worry about other schemas. All objects are created by just myself. The
two servers are partitioned so that they have volumes of same names. I have 2 questions and hope someone can shed some light:
#1. If I do a full database export and full import, will the imported tables all end up in the default ts? If so, how do I make sure they end up in the same tablespaces (ts) as they are on the Netware server? Should I manually create ts with the same names on the destination db to make sure the imported tables go to the same ts?
#1. If I do a full database export and full import, will the imported tables all end up in the default ts? If so, how do I make sure they end up in the same tablespaces (ts) as they are on the Netware server? Should I manually create ts with the same names on the destination db to make sure the imported tables go to the same ts?
0