Hi guys ,
i need to exp table but with condition and imp back to another database ,
we have 2 database and there is no link between tow server and i need to import the tables but with condition and imported again
to oracle 11g
exp abs/abs tables=texp query=abs.texp:"where hiredate > '01-JAN-13'"
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
exp abs/abs tables=texp query="where hiredate > '1-JAN-13'"
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