{"id":1005,"date":"2020-04-11T18:15:40","date_gmt":"2020-04-11T21:15:40","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=1005"},"modified":"2020-04-11T18:15:40","modified_gmt":"2020-04-11T21:15:40","slug":"ora-02304-invalid-object-identifier-literal","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2020\/04\/11\/ora-02304-invalid-object-identifier-literal\/","title":{"rendered":"ORA-02304: invalid object identifier literal"},"content":{"rendered":"

Ao realizar import me deparei com o erro:<\/p>\n

Erro<\/strong><\/p>\n

ORA-39083: Object type TYPE failed to create with error:
\nORA-02304: invalid object identifier literal<\/p>\n

Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production\nMaster table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" successfully loaded\/unloaded\nStarting \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\":  system\/********@DB directory=BKPDIR transform=disable_archive_logging:Y dumpfile=DB_FULL_09042020.DMP logfile=IMP_MIGRACAO_DB_09042020.log schemas=DB EXCLUDE=STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/USER\nORA-31684: Object type USER:\"SANKHYA\" already exists\nProcessing object type DATABASE_EXPORT\/SCHEMA\/GRANT\/SYSTEM_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ROLE_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/DEFAULT_ROLE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLESPACE_QUOTA\nProcessing object type DATABASE_EXPORT\/SCHEMA\/SEQUENCE\/SEQUENCE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TYPE\/TYPE_SPEC\nORA-39083: Object type TYPE:\"DB\".\"T_EXTRATO\" failed to create with error:\nORA-02304: invalid object identifier literal\n\nFailing sql is:\nCREATE TYPE \"DB\".\"T_EXTRATO\"   OID '117BA7FA64CE4D8D802965580CAA506B' AS OBJECT (\n        DTMOV  DATE,\n        COTACAO FLOAT,\n        VLRANT FLOAT,\n        VLRAPLICADO FLOAT\n    )<\/pre>\n
Causa:<\/strong><\/h5>\n
Retorna o erro pois o Oracle n\u00e3o permite importar dois objetos com o mesmo OID. Cada objeto deve ter OID \u00fanico no banco de dados<\/p>\n
TRANSFORM=OID:N<\/strong><\/code> parameter on the import. The transform OID:N<\/code> causes a new OID to be created for the new object, allowing the import to succeed.<\/p>\n
Checando se existe OID \u201c117BA7FA64CE4D8D802965580CAA506B\u2033<\/strong> exists or<\/p>\n
SQL> select owner,TYPE_NAME,TYPE_OID from dba_types where TYPE_OID='117BA7FA64CE4D8D802965580CAA506B<\/strong>';\n \nOWNER                          TYPE_NAME                      TYPE_OID\n------------------------------ ------------------------------ --------------------------------\nPRODUCT                 T_EXTRATO              BE4C0AFD318A07CBE0443C4A923B4794\n<\/pre>\n
 <\/p>\n
Solu\u00e7\u00e3o:<\/strong><\/h5>\n
Adionar no impdp TRANSFORM=oid:n<\/strong><\/p>\n
system\/********@DB directory=BKPDIR TRANSFORM=oid:n dumpfile=bd.dmp logfile=imp.db.log schemas=schema exclude=statistics<\/p>\n
Import: Release 12.2.0.1.0 - Production on Thu Apr 9 13:14:31 2020\n\nCopyright (c) 1982, 2017, Oracle and\/or its affiliates.  All rights reserved.\n;;;\nConnected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production\nMaster table \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\" successfully loaded\/unloaded\nStarting \"SYSTEM\".\"SYS_IMPORT_SCHEMA_01\":  system\/********@DB directory=BKPDIR TRANSFORM=oid:n dumpfile=DB_FULL_09042020.DMP logfile=IMP_MIGRACAO_DB_09042020_3.log schemas=SCHEMA EXCLUDE=STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/USER<\/pre>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Ao realizar import me deparei com o erro: Erro ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 – 64bit Production Master table “SYSTEM”.”SYS_IMPORT_SCHEMA_01″ successfully loaded\/unloaded Starting “SYSTEM”.”SYS_IMPORT_SCHEMA_01″: system\/********@DB directory=BKPDIR transform=disable_archive_logging:Y dumpfile=DB_FULL_09042020.DMP logfile=IMP_MIGRACAO_DB_09042020.log schemas=DB EXCLUDE=STATISTICS Processing object type DATABASE_EXPORT\/SCHEMA\/USER ORA-31684: Object…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[162,207,224,225,271,272,329,367,368,369,370,371],"class_list":["post-1005","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-invalid-object-identifier-literal","tag-oidn","tag-ora-02304","tag-ora-02304-invalid-object-identifier-literal","tag-ora-39083","tag-ora-39083-object-type-type-failed-to-create-with-error","tag-select-owner","tag-transform","tag-transformoidn","tag-type_name","tag-type_oid","tag-type_oid-from-dba_types-where-type_oid"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1005"}],"version-history":[{"count":1,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1005\/revisions"}],"predecessor-version":[{"id":1046,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1005\/revisions\/1046"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}