Error on exporting nested tables.

[GoogleCodeExporter]

> What steps will reproduce the problem?
  Export schema containing nested table(s).

> What is the expected output? What do you see instead?
  Raised exception: ORA-31603: object "..." of type TABLE not found in schema "..."

> What version of the product are you using? On what operating system?
  1.4, Oracle 10.2.0.3

> Please provide any additional information below.
  "select * from user_objects" return for this object object_type='TABLE', but "dbms_metadata.get_ddl(object_type => 'TABLE', name => '...', schema => '...')" raises exception ORA-31603.

  Master table was exported successfully with resulting script like:
    CREATE TABLE "<schema>"."<master_table>" 
     ("<some_field>" NUMBER NOT NULL ENABLE, 
      ... 
      "<nested_table_field>" "<schema>"."<nested_table_type>" 
     ) 
     NESTED TABLE "<nested_table_field>" STORE AS "<nested_table>";

  Then exp. <nested_table> failed.

Original issue reported on code.google.com by vadim.ke...@gmail.com on 6 Sep 2011 at 9:57

[GoogleCodeExporter]

Thanks for bug reporting

I will add in next release restriction on select user object to exclude table 
columnt in nested tables

 select *
   from user_objects uo
  where not exists (select 1
           from USER_NESTED_TABLES unt
          where uo.object_name = unt.table_name)

Original comment by resh...@gmail.com on 6 Sep 2011 at 8:12

• Changed state: Accepted

[GoogleCodeExporter]

fixed   release 1.5  
http://code.google.com/p/oracle-ddl2svn/downloads/detail?name=oracle-ddl2svn-v1.
5.zip
svn revision http://code.google.com/p/oracle-ddl2svn/source/detail?r=156

Original comment by resh...@gmail.com on 6 Sep 2011 at 8:36

• Changed state: Fixed

[GoogleCodeExporter]

Thank you for fast response! Now it's OK.

Original comment by vadim.ke...@gmail.com on 7 Sep 2011 at 5:32