DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2000
    Oracle Standard Edition
    I did an import, without rows, and all the objects were (I thought) successfully imported - Import completed without warnings. Then I import the data. Import completed without warnings. Then I attempt to rename one of the tables from DEPARTMENT_PRIMARY to DEPARTMENT_PRIMARY_HOLD. I get the ORA-00972 identifier too long error - but clearly I'm under my 30 chars. So just to see how short I have to go, I keep shortening the name until I get to:

    rename department_primary to xx;

    I STILL GET THE ERROR! AAAAAAAAhhhhhhhhhhh! What is going on?

    So, I CTAS (create table as select) to duplicate the structure of the table into a new table. I then use BMC Patrol Change Manager to compare these two objects - only difference is maxextents. So I take the DDL to create the table, all constraints and the trigger from this table, save it, drop the table and recreate it with the SQL. Now I can rename it at will.

    Why did this happen? Does it indicate some other error or problem that I need to address? Has anyone experienced this?

  2. #2
    Join Date
    Jun 2000
    from which database did U create the oracle dump and to which version were U trying to import ?, did U get any warnings or errors while U were trying to export and what was the command that U gave while U were trying to export and imprt ?
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  3. #3
    Join Date
    Aug 2000
    462 Standard Edition for export and import
    No error messages - import terminated without warnings

    The export/import didn't seem to have any problems, and I don't have any reason to believe that is even related to my problem except it was the only change to the DB before I began having this problem, and only with that one table. The data did load into the table during the import, and I could query it without problems.

    When I CTAS and made a new table, I could rename it to the name I wanted for the original. I could find no other problems with the DB.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.