Export tablespace with compress

[Former Member]

Hello Exports,

I want to export the tablespace with compress option

Env: Solaris/Oracle

Could you someone provide export sql query for oracle database..

Thanks

Malai

[Former Member]

Hello Malai,

what kind of export do you want to perform? R3load export or DataPump export?

If you want to perform an export of a tablespace via Oracle Data Pump, then have a look at the documentation:

http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/dp_overview.htm#SUTIL100

Regards,

Mark

[Former Member]

Thank you for your reply.

We need to export only one tablespace.

please let us know if any one have exp sql query with compress mode..

Thanks

malai

[Former Member]

Hello Malai,

sorry, but your question is still not clear, at least for me.

What do you mean by exp sql query with compress mode ?

Do you mean the Oracle exp tool?

I cannot see how a SQL Query could help with exporting data.

Regards,

Mark