Questions on Export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Questions on Export

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    Questions on Export

    Hi folks,

    When i am exporting, does oracle make use of
    1. Rollback segments
    2. Temporary segments

    and one more thing,
    Is there any way to find out the the user created tables owned by sys
    ie,.tables apart from the dictionary tables, coz when i do i a full export all the objects owned by sys user are not exported. So i need to separate all the user creatd tables and the base tables.

    Regards
    sonia

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    as per my knowledge

    export operation does not use rollback segments and temp segments.
    Last edited by prakashs43; 11-19-2002 at 09:21 AM.

  3. #3
    Join Date
    Nov 2002
    Posts
    170
    You can use the owner="username" parameter to export all the tables for that user no mater which tablespace the table resides.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I would suppose that if you request a consistent export, then Exp will use rollback segments to achieve this.

    For the issue of user-created objects owned by SYS, you might consider looking at the dba_objects view, and trying something like ...

    select trunc(created), count(*) from dba_objects
    where owner='SYS'
    group by trunc(created)

    TRUNC(CRE COUNT(*)
    --------- ----------
    04-MAY-00 1171
    26-JUL-00 703
    01-DEC-01 102
    20-APR-02 23
    05-SEP-02 78
    13-SEP-02 6824

    Let me tell you right now that I sure do not have any user-created objects in my SYS schema, but if I did I'd expect to see "clusters" of objects outside of times when I've upgraded/patched/installed new features.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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