Home » SQL & PL/SQL » Client Tools » Not extracting all of the data
Not extracting all of the data [message #576010] Wed, 30 January 2013 10:45 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Hi,

I exported and imported data from one oracle database to another, but not all the data got loaded in to the destination database. Basically it is filtering the data. Can it be because of the reason that the sql developer may be an express edition?
Re: Not extracting all of the data [message #576014 is a reply to message #576010] Wed, 30 January 2013 11:02 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/


How do you determine if the problem occurred during the export or the import?
Re: Not extracting all of the data [message #576019 is a reply to message #576014] Wed, 30 January 2013 13:29 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I didn't even know that SQL Developer "express edition" exists. Does it?

Anyway, data pump does the job, not SQL Developer. I also never heard that it "filters" data by itself, despite its version.

Does any clue exists in (export and import) log files?
Re: Not extracting all of the data [message #576022 is a reply to message #576019] Wed, 30 January 2013 14:12 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I am not sure whether express edition exists in sql developer. No where in the tool I see the word express edition. We can use either SQL Developer export/import option or SQL Developer Datapump option to export/import data.
Re: Not extracting all of the data [message #576023 is a reply to message #576022] Wed, 30 January 2013 14:45 Go to previous message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If it was me, I'd use data pump export and import, but at the operating system command prompt, literally typing instructions to data pump. That way, I'd be sure what I did, what I exported and I'd know what I expect to be imported. GUI is a nice tool, but only if you know how to properly use it. You - you don't even know its name, so ...

[Updated on: Wed, 30 January 2013 14:46]

Report message to a moderator

Previous Topic: very simple instruction to have in a pl/sql procedure
Next Topic: No SQL Server option in Oracle SQL Developer
Goto Forum:
  


Current Time: Wed Sep 17 18:41:02 CDT 2014

Total time taken to generate the page: 0.08573 seconds