OraFAQ Forum: Server Utilities » Changing column order using Data Pump in Oracle 10g?

Home » RDBMS Server » Server Utilities » Changing column order using Data Pump in Oracle 10g? (Oracle 10g Release 10.2.0.3.0 - 64bit on HP UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Changing column order using Data Pump in Oracle 10g? [message #442488]

Mon, 08 February 2010 08:20

AbhijitDey
Messages: 3
Registered: June 2009

Junior Member

Hello All,

We are trying to reorganize a 13m recs table having a LOB column.We plan to export this table of 6 columns and import back moving the second column to the last position in the column order using Datapump:

DATA_TABLE
(
DATA_ID VARCHAR2(255),
DATA_OBJECT BLOB, <--- the LOB segment has 1350 extents
PAGE_INDEX INTEGER,
DATA_TYPE INTEGER,
ARCHIVE_FLAG INTEGER,
ARCHIVE_DATE DATE,
WF_ID NUMBER
)

After import using data pump, the table needs to be:

DATA_TABLE
(
DATA_ID VARCHAR2(255),
PAGE_INDEX INTEGER,
DATA_TYPE INTEGER,
ARCHIVE_FLAG INTEGER,
ARCHIVE_DATE DATE,
WF_ID NUMBER
DATA_OBJECT BLOB <--- the LOB segment has 1350 extents
)

Please help...

btw,we also plan to resize the LOB structure in the process.

Thanks & Regards,
Abhijit

Report message to a moderator