132014Aug

Oracle Import Export From Remote System Using IMPDP & EXPDP

Oracle IMPDP and EXPDP Oracle provides two very good tool for importing and exporting data dump very efficiently and in very simple manner using new data pump feature. There are two ways to import data using data pump. Using IMPDP directly without dump file. Using IMPDP with dump file. Things To Consider – Utility command…

Read More
132014Aug

ORA-31679: Solved

ORA-31679: Solved ORA-31679: Table data object “Table_Name” has long columns, and longs can not be loaded/unloaded using a network link When ? ORA-31679 error occurs when we try to import the data using impdp over a network link. Why ? When the remote database contains table data object that has long columns, and longs can not…

Read More