Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Extracting relationally intact sets of data - Help is at Hand
Extracting data from Oracle databases usually means writing horrendous
scripts, administrating the necessary views and avoiding any users who
wish to change the selection criteria.
However, help is at hand. There is now available a tool that allows the user to quickly and efficiently extract relationally intact sub-sets of Oracle data. Move for Servers by Princeton Softech will extract sub-sets of data to a single compressed extract file, and then gives the user the ability to insert that extracted data to target tables which may or may not be in the same database. As part of the insertion process, the data can be manipulated, sub-stringed, superstringed, and even date aged.
The tool will also extract object ddl, allowing the user to create objects at the destination database before populating them.
The tool can even move data between different DBMS's, such as Oracle, Sybase, DB2, and SQL Server; handling the data translations for you.
If this sounds like a solution to your problems, contact me at the below
address.
Best regards
--
Alan Johns
Tarragon Software Ltd - UK & Ireland Distributor for
Princeton Softech's - Upgrade 2000 Ager 2000 Relational Tools for DB2 Move for Servers - Oracle Version Merger ELISE - the MatchMaker. Software for recruitment, estate agencies, dating agencies, etc from WCC
Phone: 44(0)1480 414141
Fax: 44(0)1480 436869
Received on Tue Jan 12 1999 - 04:26:30 CST
![]() |
![]() |