| Re: oracle - export [message #69607] |
Wed, 06 February 2002 18:30  |
R.SIVAKUMAR
Messages: 48
Registered: February 2002
|
Member |
|
|
i have used the the query.
but it shows some errors like this
LRM-00101 : unknown parameter name "QUERY"
REPLY PL
BYE
SIVA
|
|
|
|
| Re: oracle - export [message #69611 is a reply to message #69607] |
Thu, 07 February 2002 03:45  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
What oracle version are you running?
what OS?
When you type "exp80 help=y" or "exp help=y" what do you get back?
Does the query you are using work in SQLPlus?
Show the exact export command you are using.
|
|
|
|
| Re: oracle - export [message #69614 is a reply to message #69607] |
Thu, 07 February 2002 20:52 |
R.SIVAKUMAR
Messages: 48
Registered: February 2002
|
Member |
|
|
oracel version -8.0.5
OS - WINDOWS NT 4
WHEN I USING "EPX80 HELP=Y" IN DOS MODE ,
I GOT THE HELP, BUT IN THE HELP THERE IS NO KEYWORD LIKE 'QUERRY'.
PL, HELP ME
SIVA
|
|
|
|
| Re: oracle - export [message #69619 is a reply to message #69607] |
Fri, 08 February 2002 04:56 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
In your first message you stated you were using 8i. The QUERY option is not available in 8.0.5. Please in the future be specific and correct in your question so you do not waste yours or my time.
Create a temporary table (create table xxx as select...) and use the TABLES option to export it.
|
|
|
|
|
|
| Re: oracle - export [message #70075 is a reply to message #69607] |
Mon, 08 April 2002 23:31 |
Jaco
Messages: 23
Registered: August 2000
|
Junior Member |
|
|
Hello
just want to know if you know how to do the same query in export but with dates, ex. start_date > 01-JAN-2002?
Thnx, Jaco
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
