Re: Convert db Oracle 7.0 to 10g

From: Robert Klemme <>
Date: Sun, 31 Aug 2008 17:19:04 +0200
Message-ID: <>

On 31.08.2008 16:54, Matthias Hoys wrote:

> "Robert Klemme" <> wrote in message 

>> On 31.08.2008 08:08, borntoride wrote:
>>> Hi ! Thanks a lot for your time. I need to transfer data from a
>>> database in Oracle 7.0 to a new accounting software. From this new
>>> accounting software, we can import data from many type of DB, but not
>>> from Oracle....
>> A fairly easy solution might be to use MS SQL Server 2k's DTS. With that
>> you can pretty easy copy a whole schema or even DB IIRC to another
>> database. All you need is an ODBC driver.

> Can you copy procedures, pl/sql packages, users etc. with it ? Or only > tables ?

It won't copy stored procedure, function and trigger code as far as I know. I do not know a tool that does it. It might not be necessary though as it seems the OP just needs the data.

Kind regards

        robert Received on Sun Aug 31 2008 - 10:19:04 CDT

Original text of this message