| EXPORT of complex queries [message #73311] |
Mon, 22 March 2004 08:55 |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
I have this query that I need to use to load data in to a remote database. I use
sql "COPY" command to accomplish this. Can this query be used inside an export
"query" clause ??
SELECT /*+ PARALLEL(tls,6) PARALLEL(TL,6)*/
tl.* -
FROM test_limit_set tls, test_limit tl
WHERE tls.test_limit_set_sk = tl.test_limit_set_sk
AND mfg_area_name='TEST14'
AND NOT EXISTS
(select * from test_limit@saph.jove a
where tl.test_limit_sk = a.test_limit_sk)
AND NOT EXISTS
(select * from test_limit@saph.jove a
where tl.test_number = a.test_number
and tl.test_limit_set_sk = a.test_limit_set_sk) ;
This is the my parfile :
userid=saphdba/******
full=n
file=exp_tl.dmp
log=exp_tl.log
buffer=8192000
tables=sapphire.test_limit, sapphire.test_limit_set
query=" WHERE tls.test_limit_set_sk in (select test_limit_set_sk from
test_limit_set where tls.mfg_area_name='TEST14')
AND NOT EXISTS
(select * from test_limit@saph.jove a
where tl.test_limit_sk = a.test_limit_sk)
AND NOT EXISTS
(select * from test_limit@saph.jove a
where tl.test_number = a.test_number
and tl.test_limit_set_sk = a.test_limit_set_sk)"
It is erroring out with :
About to export specified tables via Conventional Path ...
Current user changed to SAPPHIRE
. . exporting table TEST_LIMIT
EXP-00056: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table TEST_LIMIT_SET
EXP-00056: ORACLE error 904 encountered
ORA-00904: invalid column name
Export terminated successfully with warnings.
Your help is appreciated...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
