OraFAQ Forum: Server Utilities » I can't export all tables

Home » RDBMS Server » Server Utilities » I can't export all tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I can't export all tables [message #675799]

Sat, 20 April 2019 10:57

alhakimy
Messages: 55
Registered: December 2016

Member

hi there

Kindly Smile

i use oracle db 11g r2

I have a database containing 102 tables
I try to export these tables
but it is Exporting only 75 table
I used more than one way to export
(sql developer program and plsql developer program) and sql plus (full=yes)
But the same result every time

What's the reason

Report message to a moderator

Re: I can't export all tables [message #675800 is a reply to message #675799]

Sat, 20 April 2019 11:16

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

alhakimy wrote on Sat, 20 April 2019 08:57

hi there

Kindly
i use oracle db 11g r2

I have a database containing 102 tables
I try to export these tables
but it is Exporting only 75 table
I used more than one way to export
(sql developer program and plsql developer program) and sql plus (full=yes)
But the same result every time

What's the reason

We can't say what is wrong since you decided to NOT actually show us exactly you do.

Which USER was logged into the database that was initiating the desired export?

BTW, sqlplus is usually not used to export tables; expdp is the actual EXPORT utility.
Which schema owns each of the 102 tables?
Does each of the 102 tables contain 1 or more rows of data?

post results of SQL below

SELECT OWNER, TABLE_NAME, NUM_ROWS FROM ALL_TABLES ORDER BY 1,2;

Report message to a moderator

Re: I can't export all tables [message #675801 is a reply to message #675800]

Sat, 20 April 2019 12:01

alhakimy
Messages: 55
Registered: December 2016

Member

thanks

I logged in from system and my user (same result)
All the tables are in my user account alhakimy
Some table contains data and the other is empty

Attachment: 2.jpg
(Size: 177.20KB, Downloaded 1432 times)

Report message to a moderator

Re: I can't export all tables [message #675803 is a reply to message #675801]

Sat, 20 April 2019 12:30

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

We still don't know what you do or what you see.
>but it is Exporting only 75 table
Post COPY & PASTE proof above is correct.

What is different between the table that are exported & tables that are not exported?

Report message to a moderator