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

Thread: Questions on Export

  1. #1
    Join Date
    May 2001
    Location
    Philippines
    Posts
    42

    Cool

    in Export Utility..
    What is the parameter CONSISTENT? how do you use it?

    How about the parameter TABLESPACES? what's its use?

    -mlringor

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    CONSISTENT
    Default: N

    Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the export command. You should specify CONSISTENT=Y when you anticipate that other applications will be updating the target data after an export has started.

    If you specify CONSISTENT=N (the default), each table is usually exported in a single transaction. However, if a table contains nested tables, the outer table and each inner table are exported as separate transactions. If a table is partitioned, each partition is exported as a separate transaction.

    Therefore, if nested tables and partitioned tables are being updated by other applications, the data that is exported could be inconsistent. To minimize this possibility, export those tables at a time when updates are not being done.

    TABLESPACES
    Default: none

    When TRANSPORT_TABLESPACE is specified as Y, use this parameter to provide a list of the tablespaces to be exported from the database into the export file.


  3. #3
    Join Date
    May 2001
    Location
    Philippines
    Posts
    42

    Cool

    hi ramiden,

    thanks for the info.

    however, can u elaborate more on the transportable_tablespace=y

    thanks.

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    The transportable tablespace feature enables you to move a set of tablespaces from one Oracle database to another.

    To move or copy a set of tablespaces, you must make the tablespaces read-only, copy the datafiles of these tablespaces, and use Export/Import to move the database information (metadata) stored in the data dictionary. Both the datafiles and the metadata export file must be copied to the target database. The transport of these files can be done using any facility for copying binary files, such as the operating system copying facility, binary-mode FTP, or publishing on CD-ROMs.

    After copying the datafiles and exporting the metadata, you can optionally put the tablespaces in read/write mode

    Export provides the following parameter keywords you can use to enable export of transportable tablespace metadata.

    TRANSPORT_TABLESPACE

    TABLESPACES

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