| Not extracting all of the data [message #576010] |
Wed, 30 January 2013 10:45  |
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 #576022 is a reply to message #576019] |
Wed, 30 January 2013 14:12  |
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 |
 |
Littlefoot
Messages: 21823
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
