Convert large volumes in Oracle

[Former Member]

I am trying to convert large tables from one instance to another (simple conversion).

Table has same layout in both systems. Doing conversion with takes ages.

So now we trying to convert via Oracle (exp/imp).

The schema-id's are different, but this issue can be tackled.

Now we found that the Oracle tables in the target system are always created with 'not null' contraint.

Now the import is impossible as a consequence.

Any ideas to tackle this, or any other ideas how to transfer large volumes.

[Former Member]

Hi,

If I understand correctly that you want to copy a table contents from a system to another. At this stage, because of the constraints, it is not allow you to insert records at the target site.

So, you exported the table from the source system, but the fields without "NOT NULL" constraint. On the other hand, at the target site, same fields have "NOT NULL" constraint.

Under this circumstance, you may create the table first without "NOT NULL" fields at the destination and import the records in it.

You can use "brspace -f tbexport ..." for the import/export operations. Check the note 646681 - Reorganizing tables with BRSPACE

Best regards,

Orkun Gedik