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

Thread: Please help... Very Urgent...

  1. #1
    Join Date
    Feb 2001
    Posts
    184
    Hi,

    I am Loading data in Production, I am having this troible so many Times, can any one please let me know how can I resolve this.

    I am inserting records in to table about 700,000 but get this error
    ERROR at line 1:
    ORA-01653: unable to extend table PMM.MEDIA_LOCATION_TRACKING by 2052 in tablespace PMM_DATA_01

    This is Storage and Other parameters specifide for thai table.
    TABLESPACE PMM_DATA_01 PCTFREE 10
    STORAGE ( INITIAL 40960 NEXT 3874816 PCTINCREASE 50 ))
    TABLESPACE PMM_DATA_01
    PCTFREE 10
    PCTUSED 40
    INITRANS 1
    MAXTRANS 255
    STORAGE (
    INITIAL 40960
    NEXT 7471104
    PCTINCREASE 50
    MINEXTENTS 1
    MAXEXTENTS 505
    FREELISTS 1 FREELIST GROUPS 1 )
    NOCACHE;

    Please let me know how can I get rid of that Error... Very Urgent.

    Thanks..

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    Check out for the extents for the table.
    Try adding another datafile and let me know. 'Cos, I too had the same problem and this worked out for me
    Badrinath

  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Hi,
    First check you have the free space availble in your tablespace. if
    yes then change the storage parameter pctincrease 0.

    if not add the datafile to the tablespace.

    Otherwise please let me know.
    i got some scripts i will send it to you.

    Good Luck.
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  4. #4
    Join Date
    Apr 2001
    Posts
    1
    oracle want add 1 extent of 2052 blocks
    if blocksize is 4 k => 8M
    8M are not disponible on the tablespace,

    you can alter the size of next extent
    alter table ... storage (next extents 2M) for example

    you can see the biggest extent disponible on your tablespace
    select max(bytes) from dba_free_space
    where tablespace_name= ...

    and adjust the next on consequence

    it's preferable to fix the pctincrease at 0 and define the initial
    extent at the good dimension and the next at 10% of the initial

    and other solution after this is to add datafile to tablespace

    i hope have respond to your problem

    sorry for my english

    if you want more information you can mail me monday
    at bertrand.claude@edf.fr
    for this week is my mail
    after bertrand.claude@free.fr

    salutations
    bertrand

  5. #5
    Join Date
    Mar 2001
    Posts
    28
    1- check the free space on hard disk
    2-ALTER TABLESPACE "t_name" DEFAULT STORAGE (
    MAXEXTENTS UNLIMITED );
    or
    2- ALTER TABLESPACE "t_name" ADD DATAFILE 'c:\tt.ora'
    SIZE 100K AUTOEXTEND ON NEXT 100K;
    M.Farouk

  6. #6
    Join Date
    Mar 2001
    Posts
    28
    you can also use this command to to expand your data files if u have space

    sql> ALTER DATABASE DATAFILE 'D:\ORANT\DATABASE\test.ORA' AUTOEXTEND ON NEXT 5M MAXSIZE 500M;
    M.Farouk

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