Home » RDBMS Server » Server Utilities » Re: oracle - export
Re: oracle - export [message #69607] Wed, 06 February 2002 18:30 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #69622 is a reply to message #69607] Fri, 08 February 2002 10:36 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Sorry for the multiple posts. I was getting an error and didn't realize it was posting each time.
Re: oracle - export [message #70075 is a reply to message #69607] Mon, 08 April 2002 23:31 Go to previous message
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
Previous Topic: svrmgrl
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Sat Dec 03 22:50:30 CST 2022