9 Replies Latest reply: Feb 26, 2013 6:21 AM by EdStevens RSS

    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.