Tag Info

New answers tagged

0

What version are you running? I'm not able to reproduce your results on 11.2.0.4. Here's my schema: 16:36:09 system@DB> select owner, sum(bytes)/1024/1024/1024 GB from dba_segments where owner = 'USER' group by owner; OWNER GB ------------------------------ ---------- USER 1156.41901 Here's ...


0

Also data pump can run in parallel, and has the option to append data, truncate tables or replace table. In addition you can change table spaces when you import. It is a better utility in every way than the older exp/imp tool.


1

Datapump is much more efficient than exp: Datapump runs within the Oracle server processes, and can read directly from the database files and write directly to a file on the server. As I understand it, data access is direct, not via SQL. exp uses the ordinary Oracle Call Interface (OCI) -- the library that Oracle provides to connect to the database. It can ...



Top 50 recent answers are included