what should i do to export the database fast?

chinni wrote:
> what should i do to export the database fast?

DATABASE_EXPORT=fast


Seriously, it depends on what it making it NOT go "fast" -- whatever
"fast" means. How many tables? How many records? How long is it
taking now? How fast do you expect it to be? What kind of disk are you
writing to? What else is going on there during the import?

Have you looked at the BUFFER parameter?

>> chinni wrote:
>> what should i do to export the database fast?


> DATABASE_EXPORT=fast

"rows=n" would help too ;-)

exp scott/tiger tables=dept rows=no statistcis=none grants=no
indexes=no file=/dev/null
:devil:

http://asktom.oracle.com/pls/ask/f?p...:1240595435323

http://www.oracledba.co.uk/tips/import_speed.htm

For me, DIRECT=Y compress=N recordlength=65535 works good.

There are faster ways to do some things than export, what are you
trying to accomplish?

jg
--
@home.com is bogus.
http://www.photomann.com/japan/machines/