Oracle 220.127.116.11.0 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?
Click Here to Expand Forum to Full Width