How about a select / insert from one to the other?

Ron

-----Original Message-----
From: Jyothish John (J)
[mailto:oracledba-ezmlmshield-x48331795.[Email address protected]
Sent: Monday, November 29, 2004 8:03 AM
To: LazyDBA Discussion
Subject: RE: Import/Export



Export the table/data to a flat file and then import it through an SP or
any other means ?

-----Original Message-----
From: Declan Heerey [mailto:oracledba-ezmlmshield-x44786805.[Email
address protected]

Sent: Monday, November 29, 2004 3:59 PM
To: LazyDBA Discussion
Subject: RE: Import/Export


NO!!! as far as I am aware the segment types are not the same and the
export will not work. I'd be happy if someone could prove this wrong
with a solution!

-----Original Message-----
From: KAREN
[mailto:oracledba-ezmlmshield-x55966187.[Email address protected]
Sent: 29 November 2004 13:57
To: LazyDBA Discussion
Subject: Import/Export



Quick question for the pros as I'm by no means a DBA Expert

Is it possible to export one table with data from an Oracle 10G personal
database running on WinXP and import into an Oracle 8.1.7 database
running on HP-UNIX??

Thank you for your time

Karen



--------
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 has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com

_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com


--------
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 its contents are subject to the Telkom SA Limited e-mail
legal notice available at

http://www.telkom.co.za/TelkomEMailLegalNotice.PDF


--------
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



Important Notice!!
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message.
Thank you.

Oracle LazyDBA home page