Re: tablespaces ddl extract script

 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.
>
>

--
http://www.freelists.org/webpage/oracle-l