Home » RDBMS Server » Server Administration » EXPORT using QUERY
EXPORT using QUERY [message #228012] Fri, 30 March 2007 13:50 Go to next message
ellicejane
Messages: 2
Registered: April 2005
Junior Member
Hi,

I hope you can help. I have an EXPORT command that uses the QUERY parameter. In one of the servers, it failed. The EXPORT version in this server is 8.0.6.3.0. I believe this is because QUERY is only available in 8i which is 8.1 and up.

Is there a way to filter data in 8.0.6.3 similar to what QUERY does? if not, what is the easiest way to upgrade the EXPORT utiliy?

Thank you!
Ellice
Re: EXPORT using QUERY [message #228021 is a reply to message #228012] Fri, 30 March 2007 14:07 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Is there a way to filter data in 8.0.6.3 similar to what QUERY does? if not, what is the easiest way to upgrade the EXPORT utiliy?

Upgrade the DB to a version that has been supported in this century.
Re: EXPORT using QUERY [message #228025 is a reply to message #228021] Fri, 30 March 2007 14:41 Go to previous messageGo to next message
ellicejane
Messages: 2
Registered: April 2005
Junior Member
Thanks for the candid answer. Razz I am working with a customer and I don't know why they are still using 8.0.6 Export version.

To upgrade the export utility, can this be done on just the utility or should the whole DB be upgraded?
Re: EXPORT using QUERY [message #228026 is a reply to message #228012] Fri, 30 March 2007 14:51 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
When transfering data via exp/imp between dissimilar versions, you MUST use the exp of the lower version DB.
This restriction is builtin & can NOT be circumvented, AFAIK.

[Updated on: Fri, 30 March 2007 14:52] by Moderator

Report message to a moderator

Re: EXPORT using QUERY [message #228262 is a reply to message #228012] Mon, 02 April 2007 05:44 Go to previous message
babai_74_cal
Messages: 6
Registered: April 2007
Location: Kolkata
Junior Member
Could you please provide the query for export???
Previous Topic: multiple instances
Next Topic: Rename table
Goto Forum:
  


Current Time: Sat Dec 03 05:49:37 CST 2016

Total time taken to generate the page: 0.05621 seconds