Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Ireland
    Posts
    9

    Angry Unanswered: ORA-00600 internal error on alter table

    I have a procedure which runs the following command

    dbms_utility.exec_ddl_statement ('alter table rp_kqi move partition part_20040130 tablespace rp_kqi_DATA');

    This errors with a ORA-00600: internal error code, arguments: [604] error but if I execute it at the SQL prompt it completes successfully.
    Any idea why?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    According to Metalink, you are attempting to split an partitioned IOT table with a user that the table does not belong to...
    Cut from Metalink...

    . Run the split partition statement from the owning schema or
    from user who is granted DBA privileges.
    or 2. Grant the following privileges to the other schema:
    System privileges: ------------------
    CREATE SESSION ALTER SESSION UNLIMITED TABLESPACE CREATE TABLE CREATE ANY TABLE ALTER ANY TABLE DROP ANY TABLE SELECT ANY TABLE CREATE ANY INDEX

    HTH
    Gregg

Posting Permissions

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