Export full DB to script

[bensmail]

Hi,

I have a full export file with no rows. Actually the export file contain 150 tablespaces and the target development database contain only one tablespace. I need to change tablespace name in the export file before importing to new database.
Do you have a Idea, how to do?

Regards
Salah Bensmail

[davey23uk]

ignore the tablespaces, just create what you need on the target and create the users with the correct default tablespace

you cant change the tablespace in the export file

[bensmail]

the great is all users are on the same default tablespace.
But when I do the import, i can not create tables, indexes because it don't find the right tablespace.
Tables are spreded on the 150 tablespaces depending on applications.

Any Idea how to correct the import?

Regards
Salah

[davey23uk]

do what i said? pre-create the users with the right tablespaces

[bensmail]

I got 150 users on the database!!
Is there any option to change the export file on a normal sql script.
Or should I do following:
1. Create a default tablespace for users.
2. Create users with the right default tablespace.
3. Import with ignore=Y

Please confirm me, if this are the right steps to do the import.

Thank's a lot

[gopu_g]

I got 150 users on the database!!
Is there any option to change the export file on a normal sql script.

SQL script,i think the export dump contails the sql to recreate the data which exported...i dont think so we can convert it into a normal sql script...

1. Create a default tablespace for users.
2. Create users with the right default tablespace.
3. Import with ignore=Y

i think davey23uk already told...u.. pr-create the users with the right tablespace...

[JChiappa]

Another option : the freeware DDLWizard ( http://www.ddlwizard.com/ ) can manipulate, alter DDLs from an Oracle export file ( .dmp) - this includes tablespace name changing - and later generate customized scripts to you, try it ...

Regards,

Chiappa

[bensmail]

Hi,
I need all objects in the export files.
I create already a default tablespace and users.

I'm really confused: The next is for me not clear. Should I go foward with imp full=y, but when i look inside the export file the tables and indexes are created belonging different tablespaces, if I execute the import the create tables will fail because the tablespaces not exist.

What should i do in the next step?


Thank's a lot.

Bensmail Salah

[davey23uk]

try it - see what happens - then you will have learned something - win for everyone

[bensmail]

Ok, then I will reply the result next week!!

Salah Bensmail