SQL & PL/SQL

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!

ROWID - data type export import

jaggyamMar 26 2010 — edited Mar 26 2010

Hi all,

I have a table which has a column of datatype ROWID. Size of the table is 5GB. When I try to export it takes 40 mins for this table. While importing it takes 7hrs to complete.

I feel it is taking more time than it is supoposed to. Is it because of the ROWID data type. Is it doing something extra, can someone throw some ilight on this.

Thanks in Advance,
Jaggyam

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2010

Added on Mar 26 2010

5 comments

1,064 views