| Logical error in Exporting [message #436680] |
Fri, 25 December 2009 05:08  |
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
|
Junior Member |
|
|
Hi, I created a directory dir_expo and a user ram. I grand all required privileges to ram for export. Then i create a table for ram as sample with 3 rows. When i export data from ram the operation was success But it showed that 0 rows are exported.
Can anyone tell reason?
F:\>expdp ram/ram dumpfile=ram_sample_dump.dmp logfile=ram_sample_log.log tables=ra
m.sample directory=dir_expo content=all
Export: Release 10.2.0.1.0 - Production on Friday, 25 December, 2009 2:56:02
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Starting "RAM"."SYS_EXPORT_TABLE_01": ram/******** dumpfile=ram_sample1_dump.dm
p logfile=hr_acc_log.log tables=ram.sample directory=dir_expo content=all
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "RAM"."SAMPLE" 0 KB 0 rows
Master table "RAM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for RAM.SYS_EXPORT_TABLE_01 is:
F:\EXPORT\RAM_SAMPLE1_DUMP.DMP
Job "RAM"."SYS_EXPORT_TABLE_01" successfully completed at 02:56:18
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
