Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    28

    Question Unanswered: What is the impact - LOCALLY MANAGE

    Hi guys
    what is the impact if we move tables and index from a tablespace A locally manage with Uniform size of 10Mo for each segments to a new tablespace B locally manage with Uniform size of 2Mo ???? we move tables by Create table_new tablespace B as select * from table_old ; The tow tablespaces A and B have got the same size for instance 50 Go for each tablespace.

    Will there be some space problem (not enough place , can't extend the segments by xx Mo) or will there be some Tuning performance problèms with data acces in SQL REQUEST ??
    Thanks for your replies ....
    Sidnet.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    it's just the size of the extent that oracle will grab next.
    so if I try to grab another 10mb extent and there is only 8mb left (no autoextend)
    then your database might come to a standstill (depending on the table).

    however, if I grab a 2mb extent and ther is only 8mb left then you are fine.

    enjoy your day.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Also, why are you using a create table to move a table. Simply use the MOVE option of the ALTER TABLE command to move it to a new tablespace. All the indexes and constraints are maintained.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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