HELP!How to convert Tamino XML DB Server to Oracle XML DB Server and/or Ora

How to convert Tamino XML DB Server to Oracle XML DB Server and/or Oracle RDBMS DB Server?

I got 240GB data stored in Tamino XML DB server. My clients request to convert them into Oracle. Since I am not familiar with Oracle XML DB Server (latest and stable version is 10?), could anybody tell is it easy to convert into Oracle?

If I convert into Oracle XML DB Server, then build a web based (J2EE) application on it, is it easy? time-consuming? If I convert it into Oracle RDBMS, is this feasible?


Tamino --> Oracle XML DB Server --> Oracle RDBMS DB Server

Updating MS SQL Server 7 DB from Oracle 7 DB

Is there a mechanism to provide transaction level replication of a Oracle 7.1.3 database into a Microsoft SQL Server 7 database? ...

Practical proposals: Migration of applied DB from Oracle to Database Server

Proposal: "Migration of an applied DB from Oracle Database Server to IBM DB2 Data Server". 1. Preface.Since DB2 9.7, IBM supports a number of the functionalities providing compatibility DB2 Data Server with Oracle Data Server.http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleap ...

registering XHTML-Transitional XML Schema into Oracle XML DB

Any help with this would be greatly appreciated.we are having a problem while registering XHTML-Transitional XML Schema into Oracle XML Db. We need the schema to be able to validate xml documents containing elements from xhtml.We downloaded the XHTML Schema to local directory and tried registering f ...

Use JDBC to Access XML Documents in Oracle XML DB

From the Oracle XML DB Developer's Guide 10g Release 1 (10.1) Chapter 12 Java API for XMLType, it show several examples for how java application use JDBC to access xml in XMLDB:1. use getOPAQUE() on XMLTYPE table/column and then call XMLTYPE.createXML();2. use getCLOBVal()/getStringVal()/getBLOBVal( ...

XML Messages into Oracle 9i db

I need help in understanding what would be the best method and tool to take XML messages and then load them into an Oracle database, which will be designed as a Datawarehouse.Base Schema Model is based on the XML Messages schema.Can some one guide me please? ...

Oracle XML DB vs/ Oracle Berkeley DB XML

HiI wonder about the benefits of having two XML DB engines for Oracle. What are the plans regarding BDX (and XDB)? ...

Migation of MS ACCESS DB to Oracle or SQL Server

I need the Case Study, approach and the methodologies for Migration of MS ACCESS DB to ORACLE 8i or 9i or SQL SERVER 2000 or 2005.... Please provide the detail Information...Rgds,Gobi... ...

Singl/Multiple Server Oracle 10g DB and AS- Advantages and DisAdvantages

I am using Application1 using Oracle 10g Application Server and Oracle 10g database.Now i planned to use Application2 using Oracle 10g AS and Oracle 10g DBI need to know what will be the Advantages and Disadvantages if i have the schema for Application2 in the existing Oracle 10g DB / having it in a ...

Create MVs in Oracle 10g DB from Oracle 9i DB using DB link

The tables of an Oracle 10g database is formed mainly (about 90%) from materialized views. These views are created using a database link extracting the data from an existing Oracle 9i database (10g connecting to 9i).The MVs created from simple queries does not take much time, but whenever a query co ...

Loading and Retrieving the data from XML file using Oracle XML

how to Loading and Retrieving the data from XML file using Oracle XML DB ...

Create MVs in Oracle 10g DB from Oracle 9i DB using DB link

The tables of an Oracle 10g database is formed mainly (about 90%) from materialized views. These views are created using a database link extracting the data from an existing Oracle 9i database.The MVs created from simple queries does not take much time, but whenever a query contains "JOINS", time fr ...

copying data from Mysql DB to Oracle 9i DB

I have one Oracle 9i databse and one Mysql databse. I need to transfer data from some tables from Mysql databse to Oracle database on regular basis, Can anybody suggest me the good way to do the same. ...

le Validating XML output against Oracle XML schema

we have a requirement where we need to extract all customer data in OIOXML (Standard in Denmark) format and FTP the data to data buyers. I need some information of how we can generate an XML in the user specified format and validate the generated XML using Oracle Pl/Sql. Once in a week we FTP nearly ...

HELP!How to convert Tamino XML DB Server to Oracle XML DB Server and/or Ora ...

How to convert Tamino XML DB Server to Oracle XML DB Server and/or Oracle RDBMS DB Server?I got 240GB data stored in Tamino XML DB server. My clients request to convert them into Oracle. Since I am not familiar with Oracle XML DB Server (latest and stable version is 10?), could anybody tell is it ea ...

Tools to Convert Tamino to Oracle RDBMS Or XML DB --> RDBMS

Please tell me:What software tool can be used to convert data from Tamino to Oracle RDBMS??? We think Tamino should be convert into Oracle XML DB first, then Oralce XML DB -> RDBMS. (P.S. ...

How can I use the FTP server on Oracle XML DB for plain text files?

I need to generate comma separated files for download via FTP. The files are generated from Oracle Table data and should be published on a FTP Server. Would it be able to use the FTP Server on Oracle XML DB?If not, any suggestions? ...

Convert DB schema to XML schema on Oracle 9i

Is there any tool I can use ?Can anyone help me on this ? ...

Tamino compare with Oracle XML DB?

As I get information from this forum, it is easy to convert Tamino to Oracle XML DB. However, could anyone tell me the big difference between Tamino and Oracle XML DB? Since Tamino costs USD$1M, I think it has its strong side. In fact, we worry about speed, because we have 270G data need to be conve ...

Oracle XML DB WebDAV in Windows Server 2003

currently, we are migrating to Windows Server 2003, but when we have tried to open a WebDAV session to view the repository, Windows didn't allow it.Please, Could anyone to help us with this issue? because I don't know how to do it. ...

logging into APEX through Oracle XML DB HTTP Server and Embedded PL/SQL

I have just finished installing Apex 3.0 on RHEL 4. I am not using HTTP Server, but Embedded PL/SQL. When I go to the page administrator page http://host:8080/pls/apex/apex_admin a prompt pops up and when I give the username as "admin" and the password then it doesn't log me in. I ran the apxconf.sq ...

Oracle Using remote ftp server with xml hierarchy as xml db repository

i am newer in Oracle XML DB, and i have question:how to use remote ftp, which contains xml files hierarchy - as xml db repository in Oracle 10 -11. Is it possible? Big ...

Oracle xml db as public file server for customers

do you think that it would be possible to use Oracle XML DB FTP service to receive files that includes orders from customers? Only some of them are in XLM format, but that seems to be no problem as the "virtual file system" of xml db is able to handle all kinds of files.All of the files have to be p ...

problems enabling Oracle XML DB HTTP Server in APEX 3.2.1/oracle 11.1.0.7

I have down loaded apex_3.2.1.zip file and following the directions on OTN, but the http://host:port/apex/apex_admin url does not work.(page not found)running this SELECT DBMS_XDB.GETHTTPPORT FROM DUAL; returns 8080.I ran script apex_epg_config and unlocked anonymous account.I also set the shared se ...

Oracle XML DB Forum support

Please, pay more attention to XML DB-it's new and very promising technology but very poorlysopported/documented(with the exception of basic features).Example excerpt from http://technet.oracle.com/tech/xml/xmldb/pdf/xmldb_92twp.pdf :1) Foldering: Enable folders to map resources (XML files) into data ...

Discoverer on top of Oracle XML DB

I would like to be able to query XML documents i Oracle XML DB through Oracle Discoverer. That is I wan't to be able to se the XML DB as relationel data.What steps should I take to make this possible? ...

Oracle Convert Sybase date to timestamp in HTML DB via Import

I tried some many format masks to convert a Sybase date/time stamp from a .xml format to a Oracle datatype timestamp. I need a example on how this can be done when I'm importing this .xls file to Oracle's HTML DB environment.The date/time stamp in Sybase looks like this:'Nov 12 2003 12:15:15:123AM'. ...

Oracle XML DB Blog anybody?

This post is for Justin Kestelyn to review. Is there a weblog for XML DB that I am not aware of? I looked for one in the list of Blogs on OTN and couldn't find one.Pretty much the only person that answers the user's questions on the XML DB forum is Mark Drake (god bless him). But, since, I see that ...

Convert SQL between Oracle and SQL Server

Hi, Is there a tool that anyone here is aware of which converts SQL, stored procedures and such stuff from Oracle compatibility to SQL Server compatibility? I have some Oracle based SQL that I wud like to convert into T-sql instead of re writing the whole T-SQL.. ...

Difficulties of build a web-based application on Oracle XML DB

Could anyone tell me:The different of development effort spend to develop the web-based application on Oracle RDBMS and Oracle XML DB.Is it difficult to develop something on Oracle XML DB? The functions are normal maintenance operations such as add, delete... Moreover, how about the SECURITY functio ...