error when trying to export the database

[rodrigovidalxc]

Environment information:
* Oracle version: 11.2
* Operating system: Win Server 2003 Enterprise

Good morning.
I am trying to make the full backup of the database but several tables are not imported, my database has approximately
1500 tables and export it only exports 531, I am performing the following command:

Select all

 
exp USUARIO/USUARIO FILE=TESTE.DMP 

Then I discovered a table that was not imported
Products

So I tried to export only it

Select all

 
exp USUARIO/USUARIO FILE=TESTE.DMP TABLES=(PRODUTOS) 

It of the error

Select all

 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set 
 
About to export specified tables via Conventional Path ... 
[b]EXP-00011: USUARIO.PRODUTOS does not exist[/b] 
Export terminated successfully with warnings. 

[/b]

[rodrigovidalxc]

I just found out what was not imported ...
I'm using Oracle 11.2
and I read in a topic that the EX command does not exports empty tables
and those that were not exported They were empty ...


How do I export empty tables?

[elidias7]

Oops!

Do you only say the structure of the tables ??

Simple, includes in the script the clause Rows = N

Hugs,

[leandrolco]

From what I am seeing the problem was that you are using a user to do the export being that it is not owner of the table:

You can place the owner in front of the table (Table = Owner .Atabela)
or
I advise using a DBA user (System, SysOper).

on the export command of the whole bank, I like to use this mode:

Select all

exp system@orcl file=export.dmp log=export.log full=y

on the export of empty tables:

follows the test of two tables that I created, one with 2 lines and another empty in the Orcling Schema.

Select all

expdp system@orcl directory=home dumpfile=teste.dmp logfile=teste.log schemas=ORCL

Log:

Select all

Processing object type SCHEMA_EXPORT/TABLE/TABLE 
. . exported "ORCL"."CHEIA"                           5.289 KB       2 rows 
. . exported "ORCL"."VAZIA"                               0 KB       0 rows

already using EXP:

Select all

exp system@orcl file=exp_teste.dmp log=exp_teste.log owner=ORCL

]] Log:

Select all

. about to export ORCL's tables via Conventional Path ... 
. . exporting table                          CHEIA          2 rows exported 
. . exporting table                          VAZIA          0 rows exported

As seen in the test, and the logs both the UTLITARIO EXP, EXPDP. Exports empty tables.