Hi Gurus,
I wrote the following exp
exp xyz/xzy file=a.dmp tables=xxx.table1 query=\'where name = 'yyy'\'
I get this error
table+export[2]: name:not found.
any ideas?
Thanks!
Printable View
Hi Gurus,
I wrote the following exp
exp xyz/xzy file=a.dmp tables=xxx.table1 query=\'where name = 'yyy'\'
I get this error
table+export[2]: name:not found.
any ideas?
Thanks!
Run the query on the table first and make sure it is valid, then put it in your export parfile. Use a LOG file too.
MH
Try this :
exp xyz/xzy file=a.dmp tables=xxx.table1 query=\"where name = \'yyy\'\"
Of course, after you make sure that 'name' is a column the 'xxx.table1' table.