DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: export in full database mode vs. user mode

  1. 04-09-2003, 04:13 PM #1
    a128
    a128 is offline Senior Member
    Join Date
    Apr 2001
    Posts
    257

    export in full database mode vs. user mode

    If I use export/import as a way to recover my DB, and my DB has only one user schema, should I export it in full database mode or user mode with the user specified? If I import to a fresh new DB with a dump file that was exported in full database mode, would it mess up the data dictionary?

    thanks,
    Reply With Quote Reply With Quote
  2. 04-09-2003, 04:23 PM #2
    svk
    svk is offline Advisor
    Join Date
    Jul 2000
    Posts
    521
    No.
    svk
    Reply With Quote Reply With Quote
  3. 04-09-2003, 04:48 PM #3
    justadba
    justadba is offline Member
    Join Date
    Apr 2001
    Posts
    108
    A user level export will not export user logins. Also will not export any objects (like synonyms) that are owned by public as public is a seperate schema. However a full export will export all the data and allow you to recover the complete database.

    However I would caution you that export/import should not be your only backup & recovery tool. You should look into adding some other method of backing up your database (hot/cold) to increase the chances of successful recovery within a timely manner.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!
    Reply With Quote Reply With Quote
  4. 04-09-2003, 05:51 PM #4
    raghud
    raghud is offline Senior Member
    Join Date
    Aug 2001
    Posts
    267
    It won't overwrite system catalog. Better to take full export. Why not?
    Raghu
    Reply With Quote Reply With Quote
  5. 04-09-2003, 07:52 PM #5
    a128
    a128 is offline Senior Member
    Join Date
    Apr 2001
    Posts
    257
    Thanks.

    One more question about exp's command line switch:

    Since FULL's defaults to N, USERS defaults to undefined, and TABLES defaults to none, what happen if none of the above switches were specified at command line?

    Will it export in Full Database, User, or Table mode?

    Thanks again.
    Last edited by a128; 04-16-2003 at 08:52 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width