DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Initial Extents

  1. #1
    Join Date
    Aug 2001
    Posts
    40
    Hi,
    can we alter initial storage value for a table.

    when i execue the following statement i am getting an error

    ORA-02203: INITIAL storage options not allowed

    alter table test storage(initial 200MB, next 100MB);

    the reason i am trying to alter the initial storage segment is i have a table which has about 2 million records and i ia m trying to import this table data into test table which is in another instance an dhas the initial storage segment very small.
    thanks


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cannot, you either move the table which is equivalent to a rebuild or export the table, then before import create an empty table with same structure and new storage parameters then import with ignore=y

    or you can use ctas, there are several ways

  3. #3
    Join Date
    Aug 2001
    Posts
    40
    If i alter the next storage segments will that work..

    when i try to use the cats from the user using a database link it says "Connection Description for remote database not found"

    but when i look at the database links i see them..
    i am not undertanding where the problem is..
    Thank You

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by pando
    ctas
    ctas = CREATE TABLE AS SELECT
    Jeff Hunter

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    As Jeff suggested you can use the CREATE TABLE AS SELECT, just remember also, you'll need to recreate your indexes and issue grants again to the newly table.

    Sometime what I do is

    a). CREATE TABLE new_table_temp AS ...

    b). Take note of the grants adn indexes.

    c). Drop the OLD table

    d). CREATE TABLE old_name AS SELECT * FROM new_table_temp

    e). Create indexes etc and grants

    f). Drop table new_table_temp;

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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