Re: export to different oracle user...

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 10 Nov 2002 16:59:56 +0000 (UTC)
Message-ID: <aqm3ac$cin$9@sparta.btinternet.com>

You could consider to use SQL*XL. Connect to the database as user1 and select the data back into Excel. Then connect to the database as user2 and pump the data back into the database.

SQL*XL specialises in dealing with databases from MS Excel. It works with all databases and has been tested to work fine against Oracle, Access, Foxpro, SQL Server, Sybase, etc etc

SQL*XL is full featured. You can use Excel cells in the SQL, it supports macro recording, VBA coding, scripting, comes with an installer/uninstaller and has a help system.

Find SQL*XL at www.oraxcel.com

I suggest you download both SQL*XL3 and SQL*XL ADO

Kind regards, Gerrit-Jan Linker Received on Sun Nov 10 2002 - 10:59:56 CST