Transferring of data

[getjbb]

Hi,

I am participating in a project that requires the transference of data from one system to another on different servers. Is Pro*C the best way to do this?

Thanks in advance for your help.

getjbb

 

[Thargy]

getjbb,

<gives Santa Mufasa's crystal ball a quick rub 'n buff up>

Nope, your guess is as good as mine. Any hints about the minor details such as operating system, source and target RDBMS technology, versions, data volumes etc?

Regards

Tharg

Grinding away at things Oracular

 

[getjbb]

Thang,

The only informtion I have is that the source is on a Microsoft 2000 server using a Microsoft Access database and the source is an Oracle 9i database (hp_unix). I know the volume is huge, but do not known an exact number.

getjbb

 

[Thargy]

getjbb,

in that case, pro*C is the last thing you should use.

In access, link the relevant oracle tables. You need to set up an appropriate ODBC source to reach the oracle database, and the DBA must grant you provileges on the tables.

Then in access, just say "INSERT INTO <target table name> SELECT * FROM <source table name>
make sure that a commit has occurred and then put your feet up.

Regards

Tharg

Grinding away at things Oracular

 

[KenCunningham]

that the source is on a Microsoft 2000 server using a Microsoft Access database and the source is an Oracle 9i database

You have two sources. I assume the Oracle database is the destination? In which case do as Tharg suggests.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[getjbb]

KenCunningham,

I meant to type destination instead of source. Nice catch. I want to thank you and Tharg for taking an interest in my question.

getjbb

 

[Turkbear]

Hi,
There are 'Gotchas' when inserting Access data into Oracle
if the Table(s) are not pre-defined in Oracle:

1: Be sure any Access MEMO fields are changed to Text, unless you want lots of LONG fields in your Oracle table
( you do not want this)

2: Watch for Column names that violate Oracle requirements ( spaces, mixed case, reserved words, etc)

Fixing the Access table's design before creating Oracle tables from them is a must - Inserting into pre-defined tables should be fine, as long as the data type/size definitions are checked.





To Paraphrase:"The Help you get is proportional to the Help you give.."