Results 1 to 2 of 2

Thread: move a table

  1. #1
    Join Date
    Feb 2003
    Posts
    23

    Arrow Unanswered: move a table

    Dear Readers,

    One of my client is on ORACLE 8.0 . His tables resides in system tablespace. How do i move there tables to users tablespace. In oracle 8I we can do the same with Alter table move tablespace <ts>.

    What are the componects of PGA ?

    What are the basic parameters that has to be edited int INIT.ORA file for a Parallel Server .


    Please mail at MANIPS15@hotmail.com and jacob.vijaykumar@itc.alstom.com


    Thanks and regards
    MANI PS

  2. #2
    Join Date
    Apr 2003
    Location
    Germany
    Posts
    25
    Hi,
    it's not so easy ...

    * export all user objects,
    * export table-ddl with OEM/or some other DDL-extacting tool
    * modify the tablespace-clause from system to users int the table-ddl-file
    * drop tables
    * import the modified table-ddl-script ( only tables nof PK/FK, .. )
    * import the export with IGNORE=Y
    * if you use CBO sample stat's again

    this should do it

    PARALLEL Settings
    * easiest set PARALLEL_AUTOMATIC_TUNING to TRUE
    * set PARALLEL_MAX_SERVERS to 8 or greater.

    At the end check up if others users can create objects in system.
    this should be forbidden if you set the QUOTA correct of the user.

    orca

Posting Permissions

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