Home » SQL & PL/SQL » SQL & PL/SQL » Porting data from Oracle 8I to XML
Porting data from Oracle 8I to XML [message #210725] Fri, 22 December 2006 01:14 Go to next message
dejiesdeoder
Messages: 4
Registered: November 2006
Junior Member
Hai
I have a client database (using oracle 8i) and a server database (oracle 10g).
Due to lack of leased line connectivity i want to port these offline data from 8i to 10g
using a modem(dial up connection).Is there is any way to port data from 8i to XML
and from XML to 10g.
thanks in advance
dejies
Re: Porting data from Oracle 8I to XML [message #210727 is a reply to message #210725] Fri, 22 December 2006 01:27 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why use XML if you only have limited bandwidth?!
Exchange plain ASCII files and use sqlloader/external tables to load those.
XML could add upto 2-3 times the size of an plain text file
Re: Porting data from Oracle 8I to XML [message #210751 is a reply to message #210727] Fri, 22 December 2006 03:31 Go to previous messageGo to next message
dejiesdeoder
Messages: 4
Registered: November 2006
Junior Member
Thanks for your advice Frank

With in 2-3 months all the offices will get leased line connectivity.so if iam using xml instead of plain textfiles to upload these datas ,it will be helpful for me in the future.
so can you suggest me any methods for this .

waiting for your reply

thanks
Dejies

Re: Porting data from Oracle 8I to XML [message #211295 is a reply to message #210725] Wed, 27 December 2006 19:31 Go to previous messageGo to next message
vadimtro
Messages: 8
Registered: December 2006
Junior Member
It is widely known that XML has been designed by text proccessing people who have no idea about data management. As a rule of thumb, touch anything "XML"-related with a long pole.

OK, here is what you do when you have connectivity. At you server database:

create dblinks clientDB;

Then depending of what you need you either copy the tables like this:

create table T as select * from T@clientDB;

or

insert into T1 as select * from T@clientDB;

If you need more sophisticated data consolidation, just amend these SQL statements.

Re: Porting data from Oracle 8I to XML [message #211298 is a reply to message #210725] Wed, 27 December 2006 19:56 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>so if iam using xml instead of plain textfiles to upload these datas
HUH?
XML files are plain text files; which happen to contain additional text to describe & delimit the actual data values!
Alternatively use datapump, exp/imp, Change Data Capture, etc.
Previous Topic: difference between functions and stored procedures
Next Topic: sending large email using oracle
Goto Forum:
  


Current Time: Fri Dec 09 21:35:03 CST 2016

Total time taken to generate the page: 0.12968 seconds