Hi,
My Environement:
+ 1 Linux Red Hat 5.4 / 32-Bit + Oracle Enterprise 10.2.0.4
+ 1 Linux Red Hat 5.4 / 64-Bit + Oracle Enterprise 11.2.0.2
+ Sample schemas scott, hr, oe,bi, pm,...
expdp system/******* parfile=table.par
where table.par contains:
DIRECTORY=EXPDMP
DUMPFILE=table.dmp
LOGFILE=table.log
TABLES=OE.ACTION_TABLE,OE.LINEITEM_TABLE
I got the following errors:
Export: Release 10.2.0.4.0 - Production on Monday, 16 May, 2011 15:46:01
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** parfile=table.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema OE was not found.
ORA-39166: Object LINEITEM_TABLE was not found.
ORA-39166: Object ACTION_TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 4 error(s) at 15:46:15
A try with the old export, where the parfile:
FILE=table.dmp
LOG=table.log
TABLES=OE.ACTION_TABLE,OE.LINEITEM_TABLE
showed the following errors:
/home/oracle/EXPORT>cat table_cmd
exp system/STRM parfile=table.par
/home/oracle/EXPORT>cat table.par
FILE=table.dmp
LOG=table.log
TABLES=OE.ACTION_TABLE,OE.LINEITEM_TABLE
/home/oracle/EXPORT>exp system/STRM parfile=table.par
Export: Release 10.2.0.4.0 - Production on Mon May 16 15:55:51 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
Current user changed to OE
EXP-00064: ACTION_TABLE is an inner nested table and cannot be exported.
EXP-00064: LINEITEM_TABLE is an inner nested table and cannot be exported.
Export terminated successfully with warnings.
/home/oracle/EXPORT>
Does anyone know the solution?
Thank for any help!
regards
hqt200475