Home » RDBMS Server » Server Utilities » Exporting sys.aud$ conditionally.
Exporting sys.aud$ conditionally. [message #143032] Tue, 18 October 2005 16:52
aratesh
Messages: 1
Registered: October 2005
Junior Member

Hi,

am trying to export the sys.aud$ based on a query since i need only a subset of the data. I am using the exp command as below and am getting an error as stated below.

Export CMD
-----------
exp man/man tables=sys.aud$ query="where TIMESTAMP#<SYSDATE-5"

Error
----

LRM-00112: multiple values not allowed for parameter 'query'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

Can anyone help here.

Thanks.
Previous Topic: SQL Loader - Multiple Update
Next Topic: exp file size
Goto Forum:
  


Current Time: Mon Jul 01 13:04:32 CDT 2024