Hi Thanx for the concern....

I am able to do it by exporting it using 9i utility.

Thanx Jon :))

-----Original Message-----
From: Kylin [mailto:[Email address protected]
Sent: 29 June 2006 17:17
To: Kumar, Niraj
Subject: Re: Oracle dump


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret **from
this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi, Kumar,

I have a most straightforward method, which can be insured to work:

1. Export(This is the verb export, not the Utility in oracle) your table
one by one to text files from 10g; 2. Build your tables in 9i 3.
Import(The same to above) from the text files one by one.

But i'm sure this is not the answer you wanna get, right?

So can you please provide some particulars, for exmaple, how many tables
are there in your db, what is the size of data, what is the OS
platform...

Sorry I've never used Oracle, just from the general view I feel you'd
better give those who can help you such kind of information. :)

Best wishes,

Qin



----- Original Message -----
From: "Kumar Niraj " [Email address protected]
To: "LazyDBA Discussion" [Email address protected]
Sent: Thursday, June 29, 2006 10:52 PM
Subject: Oracle dump


>
> Can anyone suggest how to import 10g tables to 9i....I am stuck....
>
> This e-mail and any attachments are confidential and intended solely
> for the addressee and may also be privileged or exempt from disclosure

> under applicable law. If you are not the addressee, or have received
> this e-mail in error, please notify the sender immediately, delete it
> from your system and do not copy, disclose or otherwise act upon any
> part of this e-mail or its attachments..
>
> Internet communications are not guaranteed to be secure or virus-free.

> The Barclays Group does not accept responsibility for any loss arising

> from unauthorised access to, or interference with, any Internet
> communications by any third party, or from the transmission of any
> viruses. Replies to this e-mail may be monitored by the Barclays Group

> for operational or business reasons..
>
> Any opinion or other information in this e-mail or its attachments
> that does not relate to the business of the Barclays Group is personal

> to the sender and is not given or endorsed by the Barclays Group.
>
> Barclays Bank PLC.Registered in England and Wales (registered no.
> 1026167). Registered Office: 1 Churchill Place, London, E14 5HP,
> United Kingdom.
>
> Barclays Bank PLC is authorised and regulated by the Financial
> Services Authority.
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>



This e-mail and any attachments are confidential and intended solely
for the addressee and may also be privileged or exempt from disclosure
under applicable law. If you are not the addressee, or have received
this e-mail in error, please notify the sender immediately, delete it
from your system and do not copy, disclose or otherwise act upon any
part of this e-mail or its attachments..

Internet communications are not guaranteed to be secure or virus-free.
The Barclays Group does not accept responsibility for any loss arising
from unauthorised access to, or interference with, any Internet
communications by any third party, or from the transmission of any
viruses. Replies to this e-mail may be monitored by the Barclays
Group for operational or business reasons..

Any opinion or other information in this e-mail or its attachments
that does not relate to the business of the Barclays Group is personal
to the sender and is not given or endorsed by the Barclays Group.

Barclays Bank PLC.Registered in England and Wales (registered no. 1026167).
Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.

Barclays Bank PLC is authorised and regulated by the Financial Services Authority.

Oracle LazyDBA home page