nirav


{ City } ahmedabad
< Country > india
* Profession * dba
User No # 73411
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 23
Users Marked my Answers as Wrong # 1
Questions / { nirav }
Questions Answers Category Views Company eMail




Answers / { nirav }

Question { Mphasis, 19844 }

why Datapump is faster than traditional export and import


Answer

The Data Pump is a server based utility vs. the traditional
Export / Import which are client based utilities. The
Oracle Data Pump is not compatible with the Export / Import
functionality.

The Oracle Data Pump can also use NETWORK_LINK
functionality to move data and metadata from a remote
database without a dumpfile using the network technology
between the two databases.

Is This Answer Correct ?    18 Yes 1 No

Question { Mphasis, 4112 }

orra 1555 what is this error,why it is occur?


Answer

The "ORA-01555 snapshot too old" error, which causes user
transactions to fail, is a nightmare for Oracle DBAs and
developers. It usually occurs after queries or batch
processes have been running for a long time, which means
you can lose many hours of processing when the error crops
up.

Is This Answer Correct ?    5 Yes 0 No