9 Replies Latest reply on Feb 26, 2013 12:21 PM by EdStevens

    Table with no rows does not exported through export utility in 11g release2


      I am using 11g Release 2 and taking export through exp command but exp does not export those tables which are created but no data inserted in the tables.

      I have created a table create table test(id int, des varchar2(10)); and than export the schema with following

      exp accounts/accounts file=accounts.dmp log=accounts_exp.log owner=accounts rows=y compress=y

      All tables are exported except test table . Then i tried to export single test table but i got error EXP-00011: accounts.test does not exist

      After that i insert a row in test table and then export the schema then all tables are exported including test table.

      while in 11g release 1 its working fine .

      Is there any body help me in this regard.