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 " <oracledba-ezmlmshield-x97631018.[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
>
>
Oracle LazyDBA home page