Re: Export Problem

Raghu wrote:

>Is it possible in Oracle9i to sort data based on a specific column,
>before importing it?
>If not, is there any other method for this?

Your question isn't too clear. What exactly are you trying to accomplish? If you think you need to load data in a particular order to get it out in a particular order, you need to read the Concepts Manual. If you want to use the sqlloader direct load as described in the Utilities manual, you need to use something besides export to get the data into a flat file.

Also, you need to specify what environment you are working in, some environments let you sort things outside of Oracle.

Also, see the syntax for CREATE TABLE AS SELECT...

jg

-- 
@home.com is bogus.  http://news.com.com/2300-11395_3-5905480-2.html