Home » RDBMS Server » Server Utilities » Logical error in Exporting (10.2.0, Win XP)
Logical error in Exporting [message #436680] Fri, 25 December 2009 05:08 Go to next message
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
Re: Logical error in Exporting [message #436684 is a reply to message #436680] Fri, 25 December 2009 07:58 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>Then i create a table for ram as sample with 3 rows.

Post output of the below query.

select count(*) from ram.sample;

- Babu

[Updated on: Fri, 25 December 2009 07:59]

Report message to a moderator

Re: Logical error in Exporting [message #436692 is a reply to message #436684] Fri, 25 December 2009 11:10 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
The output of the below query is
select count(*) from ram.sample;

SQL> select count(*) from ram.sample;

COUNT(*)
----------
3
Re: Logical error in Exporting [message #436696 is a reply to message #436680] Fri, 25 December 2009 14:17 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
expdp ram/ram dumpfile=ram_sample_dump.dmp logfile=ram_sample_log.log tables=sample directory=dir_expo content=all

try again using above
Previous Topic: How to create dbms_reputil package in the database?
Next Topic: How to "clean" Oracle database before importing
Goto Forum:
  


Current Time: Fri Dec 09 13:50:40 CST 2016

Total time taken to generate the page: 0.14467 seconds