This content has been marked as final. Show 3 replies
Pl post details of OS and database versions.
The exports created by Oracle (original exp and expdp) are in a proprietary format and are not readable by third party software. Pl elaborate more on your requirements. Looks like you will have to write SQL scripts to extract required data and then load it into the target database.
You may want to contact Netezza to see if they have any utilities to extract data from Oracle databases.
Yes you are right srini.My requirement is i am doing automation,so I have two tables in oracle database from which i have to query data Eg: values education=0 or 1 or 2.
From the data received I have tables in Netezza database to check whether these education values 0 or 1 or 2 are present in these tables.So i am not sure how to proceed.
Oralce version : Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
Netezza version : Release 6.0.5 (P-8) [Build 23875]
Are you stating that you need to have both databases and run queries against both databases ? If so, you will need to install gateways and heterogeneous services
If this is not your requirement, then please elaborate