Hi,
it's a good resource for you. you should use impdp for import.
ORACLE-BASE - Oracle Data Pump (expdp and impdp) in Oracle Database 10g
Regards
Unfortunately this does not answer my original questions.
Is it favorable to use dpexp instead of regular exp and how do I import.
My Oracle ver is 10 to 11.
>Is it favorable to use dpexp instead of regular exp
yes, use expdp
>and how do I import.
impdp
Hi,
I think you should use Datapump? (expdp and impdp)
dpexp what is it?
if it is SQLDeveloper's dump file, probably it is expdp. You can find out which program is used by SQLDeveloper to export data.
if it's expdp, you can use impdp
Regards
Unfortunately I cannot use datapump export/import since my version from which to export is 10g. So it is saying data pump client is incompitable.
d96a096c-0f72-451e-9b43-2cf14a47c144 wrote:
Unfortunately I cannot use datapump export/import since my version from which to export is 10g. So it is saying data pump client is incompitable.
V10 oracle supports expdp & impdp
If/when different Oracle versions are involved the lower version of export must be used or specify VERSION={lower version#}
Please don't use sql developer for this
just use expdp and impdp from command prompt. Use oracle base website I sent
As sb92075 said, 10g support datapump
Regards
