Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migration from Postgresql to Oracle

922027Mar 6 2012 — edited Mar 19 2012
Hi,
I want to migarte Array data type of Postgresql to Oracle.
I have a table with 3 columns having array data type.
Can i go with Nested Tables?
If yes then, Is there any performance loss?

I have below table in postgre and i want to migrate it in Oracle.
CREATE TABLE EMP_DETAIL
2 ( "ID" Integer PRIMARY KEY,
3 "NAME" Text,
4 "DESCRIPTION" ARRAY,
5 "CITY_ALLOC" ARRAY,
6 "LANGUAGE" ARRAY
)
/

Please suggest the best Approach...

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2012
Added on Mar 6 2012
11 comments
1,451 views