I want to import data in Oracle on Windows. The export (dump) file is taken from Oracle running on Unix. Please advise. Thanks.
The dump file generated by either the Export utility (exp) or Data Pump (expdp) is platform-independent. So even though the source database is running on Unix, you can use the Import utility (imp) or Data Pump (impdp) to perform the import on Windows. Simply FTP the file to the destination server in binary mode and use the correct utility. Refer the your version's Utilities Guide for more information.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.