add tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: add tablespace

  1. #1
    Join Date
    Mar 2007
    Posts
    20

    add tablespace

    Hi,

    thanq 4 the help, giv me one example to add tablespace in one db to another db(either tronsportable or import export).

    plz help,

    regards

    sunil

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    look up transportable tablespaces in the documentation

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    You can use TTS method or impdp/expdp to achieve this. Lots of documents available online, just need to google them.

  4. #4
    Join Date
    Dec 2008
    Posts
    9
    PROCEDURE TO SHARE TABLESPACE
    -----------------------------

    The procedure to share the tablespace between two databases, the owner
    database and the target database, is to use the transportable tablespace
    feature in Oracle 8i. Both tablespaces must always be READ ONLY.

    a. In the source database, make the tablespace READ ONLY

    b. Export the tablespace from the source database using the transportable
    tablespace option

    c. Take the tablespace OFFLINE in the source database.

    d. Physically copy the datafile(s) associated with this tablespce to the destination
    database.

    e. Import the tablespace into the destination database using the transportable
    tablespace option.

    f. Put the tablespace ONLINE in the source database.


    PROCEDURE TO UPDATE THE SHARE TABLESPACE
    ----------------------------------------

    a. In the destination database, drop the tablespace.

    b. In the source database, change the tablespace to READ WRITE.

    c. In the source database, update the data / structure of the tablespace.

    d. In the source database change the tablespace to READ ONLY.

    e. Export the tablespace from the source database using the transportable
    tablespace option.

    f. Take the tablespace OFFLINE in the source database.

    g. Physically copy the datafile(s) associated with this tablespace to the destination
    database.

    g. Import the tablespace into the destination database using the transportable
    tablespace option.

    h. Put the tablespace ONLINE in the source database.

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