Home » RDBMS Server » Server Utilities » I can't export all tables
I can't export all tables [message #675799] Sat, 20 April 2019 10:57 Go to next message
alhakimy
Messages: 43
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
Re: I can't export all tables [message #675800 is a reply to message #675799] Sat, 20 April 2019 11:16 Go to previous messageGo to next message
BlackSwan
Messages: 26640
Registered: January 2009
Location: SoCal
Senior Member
alhakimy wrote on Sat, 20 April 2019 08:57
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

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;
Re: I can't export all tables [message #675801 is a reply to message #675800] Sat, 20 April 2019 12:01 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
thanks/foru/forum/fa/14093/0/

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 759 times)
Re: I can't export all tables [message #675803 is a reply to message #675801] Sat, 20 April 2019 12:30 Go to previous messageGo to next message
BlackSwan
Messages: 26640
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?
Re: I can't export all tables [message #675804 is a reply to message #675803] Sun, 21 April 2019 01:19 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
thank u Mr BlackSwan for following me

Apply the sentence
ALTER TABLE table_name ALLOCATE EXTENT;
For all tables 102
All tables were exported
Re: I can't export all tables [message #675805 is a reply to message #675804] Sun, 21 April 2019 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 26640
Registered: January 2009
Location: SoCal
Senior Member
alhakimy wrote on Sat, 20 April 2019 23:19
thank u Mr BlackSwan for following me

Apply the sentence
ALTER TABLE table_name ALLOCATE EXTENT;
For all tables 102
All tables were exported

So, the answer to my original question below was "NO!".
>Does each of the 102 tables contain 1 or more rows of data?
Re: I can't export all tables [message #675819 is a reply to message #675805] Mon, 22 April 2019 03:42 Go to previous messageGo to next message
alhakimy
Messages: 43
Registered: December 2016
Member
But there was an empty tables
And were exported
As in the attached picture
Re: I can't export all tables [message #675827 is a reply to message #675819] Mon, 22 April 2019 10:19 Go to previous messageGo to next message
Michel Cadot
Messages: 66714
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It depends if the segment(s) associated to the table has been allocated or not.

Re: I can't export all tables [message #675844 is a reply to message #675827] Tue, 23 April 2019 09:09 Go to previous message
alhakimy
Messages: 43
Registered: December 2016
Member
thank you so much for cooperating
Previous Topic: ORA-19032 Expected XML tag but go no content
Next Topic: Script to run EXPDP
Goto Forum:
  


Current Time: Sat Dec 07 06:03:40 CST 2019