Oracle x Postgre

[enable]

I want to migrate from Postgre to Oracle. I would like to know where I find information like comparative tables between the two SGBDs.

Since already thank you,
the newest attendant frequent

[dr_gori]

Eae enable, welcome.

About your migration:
* If for few tables, sometimes it is worth exporting to the text and loading in Oracle with SQL * loader.

Honestly, I never migrated from Postgre Pro Oracle, so I do not know the structure very well. What I know is that Postgre is very much like Oracle. I have seen a system that the packages and procedures were converted from a bank to another, and the system was compatible with the 2 banks. (this because even the language of the posgre is very similar with Oracle)

Sorry I can not help you ... If you find out something, poe here for guys :-d

[TBou]

Rapaiz I had a crazy problem here with Postgre tmb ..
Tipow ... I have a system from Jonh Deere that uses Postgre and wanted to do the daily import of movements for a corporate managerial system that I have here in the Empsa .
Then a colleague of mine who is DBA managed to set up a dblink for Oracle to see the postgre base ... works very well.

What I can do is see with him if He would have interest in passing some information or even set up the connection to you ....

I will see if I can inforations about it

[JOPA]

Hello,

I am facing the same problem.

There are several banks with the same structure in cities / municipalities
from here, which I created the structure of the base in Oracle and Dblinks
for each.

It turns out that in tables with more than 4 million records, by
example, I can not finalize a simple consultation of a specific
record. It is worth knowing that there is index in the table and my query is all
focused on the index.

Executing this query at the PostgreSQL base in less than 1 minute I
I have the result.

I think of generating in each seat of each location a .txt file and
load here in Oracle but, I do not know how to proceed.

Does anyone have any idea how to proceed? ... Experience in situations
Similar to mine?

[diegolenhardt]

About DBLink, beware when using Funcoes in SELECT, because when using DBLink, the entire result of SELECT is brought to the Oracle Bank Machine, so please make the consultation, in case 4 million,

post your query ..

[JOPA]

Hello Diegolenhardt,

I am taking care of the consultations on the base
use of its corresponding dblink.

Imagen a client table where your primary key is clientcod,
right?
Your query base has more than 4 million records and your query is:

Select all

SELECT * FROM "clientes"@meu_dblink WHERE "clienteCod" = 10;

It seems that Oracle brings the whole Base to then sweep in
search for the required result.

I thought about creating views at the base of PostgreSQL to minimize
number of records, not failing to be within what I need
but, as the base undergoes updating and Communication is a little
Failure, the solution tends to stay on the server.

I'm studying SQL * loader to see what's going to do but, anything
we're here.

grateful !!!

[diegolenhardt]

SQL Loader is rapid, I believe it's the best way out,

[JOPA]

It seems to me that yes.

However, my biggest challenge is to create a "script" or do not know what to generate
.txt files on each server, within a format I need
Study so yes: Kill in the chest and do goool.

Note: Linux server and PostgreSQL Bank 8.2.5

[diegolenhardt]

Putz do not know much of PostgreSQL, in Oracle would use UTL_File,

= /

[JOPA]

Reviewing some posts of mine I ended up returning here.

I know that I have already got a solution to my problem. It took place
with the generation of .txt files and SQL * loader into the bank
Oracle.

As the scattered servers are UNIX, scheduled scripts were created
via cron aligned to the client business. Another equipment with
Windows, Bats do the collection work / scan on each server
on the files created and, in it, the SQL * loader sends it inside.

After that is Oracle and a hug.

until !!!