Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Longraw Copy Utility?

Longraw Copy Utility?

From: Lee Parsons <lparsons_at_eskimo.com>
Date: 11 Aug 1998 20:04:16 GMT
Message-ID: <6qq840$sbp$1@eskinews.eskimo.com>


I have a customer that will need to make structure changes to a table containing longraws as part of a future migration process. (ie. Drop a column) Obviously "create table as" and "Copy" can not be used because of the Raw column.

I can load the table manually using SQL*Loader but I currently don't have a way of unloading. I realize I can write a PRO*C program to do the migration for me, but I'm hoping a tool already exists.

Ideally, we want something that will read the table and populate the new table without writing out to the OS. But at this stage we'll take what ever works.

Does anybody know of a shareware (or cheap) migration tool that might fit the bill?

Thanks for the help,

Lee Parsons Received on Tue Aug 11 1998 - 15:04:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US