Export with TABLESPACE option!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Export with TABLESPACE option!

  1. #1
    Join Date
    Feb 2001
    Posts
    286

    Export with TABLESPACE option!

    Hi all!

    Queries:

    1.say a table EMP is stored in a tablespace ABC.Primary Key index PK_INDX is stored in ABC tablespace.P1 partition of sales Table is stored in ABC tablespace.

    Now if we export with Tablespace = ABC,WHAT OBJECTS ARE EXPORTED:

    a).EMP,P1 partition,PK_INDX Index.
    b).Only EMP,PK_INDX.


    2.I have not used OEM but I have a Query as below:

    Could HTML Reports run:
    a).With a Repository.
    b).Without a repository.

    Thanks & regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    As far as I'm aware the table, index and table to which the partiotion belongs will be exported.

    The index will be exported no matter where it is stored if it's corresponding table is exported (unless indexes=N) and all partiotions of a table will be exported if a partition exists in an exported tablespace.

    Hope that makes sense

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    As a general rule "ALWAYS TAKE MORE THAN YOU NEED" when it comes to export. You never know what will happen and what you will need later.
    Since indexes are not really export (only their DDL is) it is always a good idea to take the indexes as well.

    Or, to be safe, do an export...
    FULL=Y
    ROWS=N

    This will grab all the .DDL for the database and leave the data, this way you will have "backups" of all your structures. It takes about 2 minutes too.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Feb 2001
    Posts
    286

    Hi Mr.hanky,Jovery!

    Hi!

    Thanks forthe reply.My doubts are cleared!Thanks forputting in the effort.

    Regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  5. #5
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    It will cause an error. You can only transport a set of tablespaces that is self-contained. See Oracle 9i Administrator Guide P11-31 for information about transporting tablespaces.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  6. #6
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Smile

    When you use TABLESPACES= ... in the exp par file, all tables in this tablespace will be included in the dump file.

    This includes all tables contained in the tablespace and all tables that have a partition located in the TABLESPACES=... list. Indexes are exported with their tables, regardless fo where the index is stored.


    Hope that helps,

    clio_usa
    OCP 8/8i/9i DBA

    Visit our Oracle DBA site

  7. #7
    Join Date
    Feb 2001
    Posts
    286

    Hi all!

    I thanks all for replying.I got my doubts cleared considering your
    experienced guys replies.

    Regards,

    Take care.

    Amit.
    Oracle DBA (OCP) v8i,v9i

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