Results 1 to 3 of 3

Thread: Export database

  1. #1
    Join Date
    Feb 2009
    Posts
    8

    Unanswered: Export database

    Hi all,

    How can I know the estimation capacity I need to do an export full of my database?

    Consulting the dba_extends is sufficient? or exist a best way?

    I'm using a 9.2.0.8 Oracle

    Regards,
    Jordi

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Total K used

    Try this:
    Code:
    COMP SUM OF total_k_used on report
    break on report
    SELECT   d.tablespace_name, SUM (d.BYTES) / 1024 total_k,
             NVL (SUM (f.BYTES) / 1024, 0) total_k_free,
             (SUM (d.BYTES) - NVL (SUM (f.BYTES), 0)) / 1024 total_k_used
        FROM SYS.dba_data_files d, SYS.dba_free_space f
       WHERE d.tablespace_name = f.tablespace_name(+)
    GROUP BY d.tablespace_name;
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Feb 2009
    Posts
    8
    OK, thank you!

Posting Permissions

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