FULL Export/Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: FULL Export/Import

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi Guys,

    I have taken FULL export of D.B with COMPRESS=Y option. Now I want to import it back in the same Database.

    Main purpose of full export/import is to remove fragmentation and reorganize the database.

    Do I have to first drop all the users with cascade to make the database empty keeping only SYS and SYSTEM users?

    Do I have to do import with IGNORE=Y.

    Pl. help to clarify.

    Thanks in Adv.



    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Keep the users, drop all their objects. Use something similar to http://home.adelphia.net/~marist89/s...ipe_schema.htm to whack all the objects.

    If you use this method, you will not have to worry about IGNORE flag.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Originally posted by marist89
    Keep the users, drop all their objects. Use something similar to http://home.adelphia.net/~marist89/s...ipe_schema.htm to whack all the objects.

    If you use this method, you will not have to worry about IGNORE flag.
    Hi,

    Thanks.

    I have to ignore SYS,SYSTEM users while dropping all objects. Right?

    Another good question:

    I want to import the database A into Database B. Both have different table structures and also difference in objects.

    Can I still import B into A?

    Thanks.


    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by samdba
    I have to ignore SYS,SYSTEM users while dropping all objects. Right?

    Another good question:

    Ah, yeah. Only drop those objects in which you will be importing the owners.


    I want to import the database A into Database B. Both have different table structures and also difference in objects.
    No problem, as long as the objects are dropped on the destination db before you import.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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