Re: export Oracle7 - import Oracle8

Nope. Tablespaces can have their files stored anywhere you fancy, and Oracle couldn't give a monkey's.

Tablespace are merely logical wrappers around the physical files. They have no physical existence in their own right. So the dump file says 'create emp... tablespace BLAH'. That's not a lot of help in and of itself -it's the fact that the control file happens to know that BLAH is made up of the physical file /u01/oradata/bing/bong/blah01.dbf that then allows the create table statement to mean something in terms of data placement. Whether the controlfile says the physical file is at /u01/oradata/bing/bong/blah01.dbf or /bong/bing/squiggle/blah99.hjr is a matter of complete indifference to the "create table" statement.

(Which is, incidentally, why moving a datafile at the O/S level requires you to come back to the database and tell it (ie, the controlfile) what you've done with an 'alter database rename file' or 'alter tablespace rename datafile' command).

Regards
HJR "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news:a3pa46$nj6$1_at_as201.hinet.hr...
> Does these tablespaces have to use the same files? Problem is that my
> original tablespaces were in files residing on E:\ disk and my comp
> where I want to import the dump does not have E:\ disk at all.
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
Received on Tue Feb 05 2002 - 13:30:29 CST