Export full DB to script
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Export full DB to script

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    Cool Export full DB to script

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do what i said? pre-create the users with the right tablespaces

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    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

  6. #6
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by bensmail
    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...
    Last edited by gopu_g; 09-25-2008 at 01:01 PM.

  7. #7
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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

  8. #8
    Join Date
    Mar 2002
    Posts
    301
    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

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    try it - see what happens - then you will have learned something - win for everyone

  10. #10
    Join Date
    Mar 2002
    Posts
    301
    Ok, then I will reply the result next week!!

    Salah Bensmail

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width