Re: Question on conversion LONG RAW to BLOB

As I understand table CR can have many sections and every section can have many files.

Old structure had relation: Table Field -> Section by section_id.

Where is a relation to Section in the new structure:

tb__CR_Attachment
cr_no (PK business generated)

appl_id (PK  business generated)
file_name
file_content BLOB
file_section

What do cr_no and appl_id fields mean?
Also which field in old structure shows relation between Field and CR_Attach?

Best regards, Dmitry.

--
www.ispirer.com - Database migration tools and services for Oracle and IBM
DB2.




>>>>>>>>>

"PWGSC/TPSGC" <Pascale.Panter_at_pwgsc.gc.ca> wrote in message
news:3AACD802.77340806_at_pwgsc.gc.ca...
Current tables (we just upgraded to Oracle8):

Table CR
cr_id (PKsystem-generated)
appl_id
cr_no

Table Section
section_id (PK system-generated)
cr_id
file_type

Table Field
field_id (PK system-generated)
section_id
file_section

Table CR_Attach
cr_id (PK system-generated)
cr_no
file_type
file_name
file_content LONG RAW

As these database structure was poor, changes have to be made and tables
Field and CR_Attach will now be in the same table:

tb__CR_Attachment
cr_no (PK business generated)
appl_id (PK  business generated)
file_name
file_content BLOB
file_section

One file_section may have may files (attachments) for one CR, a CR having
more than one file_section (A, B, C, etc.)
Hope this will help you to help me!



>Dmitry wrote:

>Hi,

>What kind of structure convertion in addition to LONG RAW->BLOB do you need

>to perform?

>Could you provide an example?

>Best regards, Dmitry.

>--

>www.ispirer.com - Database migration tools and services for Oracle and IBM

>DB2.

"Pascale Panter" <"pascale.panter"@pwgsc.gc.ca;pascale.panter_at_sympatico.ca>
wrote in message news:lrUq6.361399$Pm2.5427787_at_news20.bellglobal.com...


> I have to import data from an Oracle8 database to another Oracle8

> database:

> - not same structure

> - LONG RAW field in one table from the ols database will become a BLOB

> in the new database.

>

> SELECT ... INSERT statement doesn't work. Export/Import using SQL*Loader

> is not feasible because of the change of the database structure.

>

> Can somebody help me on what to do to achieve the conversion (PL/SQL

> program?) ?

>

> Thanks!

>