From your post I understand that you have the same mount points with
the same directory structure on the new server.
You can just do export with rows=n and import it on the other side.
This will build all your tablespaces.
You can then delete all users with cascade and all the objects will go away.
I think that you need to check another option before you export/import a
database of this size. A short time ago someone on the list suggested
upgrading the source database to 10g and then using tablespace
export/import to 10g on the new server. If you do not want to upgrade
maybe you can set competability level to 9i and run with 10g.
Adar Yechiel Rechovot, Israel
The Human Fly wrote:
Friends,
My mgmt. has decided to move our datawarehouse, around 1.5 TB from AIX
server to HP-SUPERDOM. We are using oracle 9i and only export and
import possible, I believe. This database has around 100 tbs.
-- //www.freelists.org/webpage/oracle-l
