Help required for getting create index DDL on partitioned table. [message #656761] |
Tue, 18 October 2016 05:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b69a15eb1f3eaa0ea6558f32108cf3af?s=64&d=mm&r=g) |
msol25
Messages: 396 Registered: June 2011
|
Senior Member |
|
|
Hi All,
when executing below script in Production at that time getting below error:
select dbms_metadata.get_ddl('INDEX','IDX_SP_OPP_ALL_FLAT1','DNA_OWNER')
from dual;
Error :
-----
ORA-31603: object "IDX_SP_OPP_ALL_FLAT1" of type INDEX not found in schema "DNA_OWNER"
ORA-06512: at "SYS.DBMS_METADATA", line 5088
ORA-06512: at "SYS.DBMS_METADATA", line 7589
ORA-06512: at line 1
31603. 00000 - "object \"%s\" of type %s not found in schema \"%s\""
*Cause: The specified object was not found in the database.
*Action: Correct the object specification and try the call again.
[Updated on: Tue, 18 October 2016 05:27] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|