Lost my seq$ system table
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 34

Thread: Lost my seq$ system table

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Lost my seq$ system table

    Hi Experts

    How to recover seq$ system table?

    Regards
    sumit

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Why? How did u arrive at this idea of recovering a system table? Do you get any errors? If so, post them verbatim.

    HTHU.

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Run this as sys as sysdba.

    Code:
    CREATE TABLE SEQ$
    (
      OBJ#        NUMBER                            NOT NULL,
      INCREMENT$  NUMBER                            NOT NULL,
      MINVALUE    NUMBER,
      MAXVALUE    NUMBER,
      CYCLE#      NUMBER                            NOT NULL,
      ORDER$      NUMBER                            NOT NULL,
      CACHE       NUMBER                            NOT NULL,
      HIGHWATER   NUMBER                            NOT NULL,
      AUDIT$      VARCHAR2(38)                      NOT NULL,
      FLAGS       NUMBER
    )
    TABLESPACE SYSTEM
    PCTUSED    40
    PCTFREE    10
    INITRANS   1
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                PCTINCREASE      0
                FREELISTS        1
                FREELIST GROUPS  1
                BUFFER_POOL      DEFAULT
               )
    LOGGING 
    NOCACHE
    NOPARALLEL;
    
    
    CREATE UNIQUE INDEX I_SEQ1 ON SEQ$
    (OBJ#)
    LOGGING
    TABLESPACE SYSTEM
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                PCTINCREASE      0
                FREELISTS        1
                FREELIST GROUPS  1
                BUFFER_POOL      DEFAULT
               )
    NOPARALLEL;
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    This script is for 9iR2 databases.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    will that work? doubt it really

  6. #6
    Join Date
    Dec 2001
    Posts
    203
    Hi
    I am getting the following error. I shutdown my database as 'shutdown immediate';

    SQL> startup
    ORACLE instance started.

    Total System Global Area 135338868 bytes
    Fixed Size 453492 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    ORA-01092: ORACLE instance terminated. Disconnection forced

    my alter log file
    =================
    Mon Apr 21 15:35:30 2003
    Errors in file d:\oracle\admin\buchku\udump\buchku_ora_1576.trc:
    ORA-00942: table or view does not exist

    Error 942 happened during db open, shutting down database
    USER: terminating instance due to error 942
    Instance terminated by USER, pid = 1576
    ORA-1092 signalled during: ALTER DATABASE OPEN...

    I know it is seq$ table, what got deleted

    Regards
    sumit

  7. #7
    Join Date
    Dec 2001
    Posts
    203
    Hi Adweri

    My database is Oracle 9i and release 2, but I can not startup my database presently. So how to execute your stuff?

    Pls need help.

    Regards
    sumit

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to do some recovery, itīs not that easy to recover a data dictionary table, we wish huh

  9. #9
    Join Date
    Dec 2001
    Posts
    203
    Hi Pando,

    I tried the same now.

    SQL> startup mount;
    ORACLE instance started.

    Total System Global Area 135338868 bytes
    Fixed Size 453492 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    Database mounted.

    SQL> recover automatic database;
    Media recovery complete.

    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    Please help me to come out from this problem. I highly appreciate your time.

    Regards
    sumit

  10. #10
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by sumit
    Errors in file d:\oracle\admin\buchku\udump\buchku_ora_1576.trc
    What is the contents of the above file? BTW, how are u so sure it is seq$ table? Hope u did not delete it yourself?

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