0

I use command 

exp SYSTEM/SYSTEM@dbInstance owner=user file=c:\exp.dmp

to export my tables.

The result is only 4 tables has been exported.

But when I use sqlplus with this user and use SQL

select table_name from user_tables

to show the tables of this user, the result is 117.

I don't know the reason why this happened.

Neo Jiang
  • 11
  • 2
  • hi, post the result of the export, we need to see the log it produces – davegreen100 Jul 09 '15 at 08:09
  • @davegreen100 since i'm using the japanese version oracle, maybe it will be hard for u to read the log. But i can tell you that the last line in the log shows that export end without warning – Neo Jiang Jul 10 '15 at 05:51
  • @davegreen100 could you please tell me what may cause this problem? I will check the point and feedback the result. – Neo Jiang Jul 10 '15 at 06:01
  • without seeing the log i would be guessing, maybe a space problem on the server giving you an incomplete export. Check the log for anything which says ERROR or INCOMPLETE – davegreen100 Jul 10 '15 at 07:39
  • @davegreen100 solved. The problem is that Oracle11 defaultly won't export empty table. So i use `alter table TABLE_NAME allocate extent;` to allocate empty tables and then i works :). Thx whatever – Neo Jiang Jul 13 '15 at 06:01

0 Answers0