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)
Changing column order using Data Pump in Oracle 10g? [message #442488] Mon, 08 February 2010 08:20 Go to next message
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
Re: Changing column order using Data Pump in Oracle 10g? [message #442490 is a reply to message #442488] Mon, 08 February 2010 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
in SQL the order of columns is not relevant.
Re: Changing column order using Data Pump in Oracle 10g? [message #442491 is a reply to message #442490] Mon, 08 February 2010 08:53 Go to previous messageGo to next message
AbhijitDey
Messages: 3
Registered: June 2009
Junior Member
Thanks BlackSwan.. Thats what I was thinking too.

probably then Oracle data pump doesnt allow re-order of columns then?

Best Regards,
Abhijit
Re: Changing column order using Data Pump in Oracle 10g? [message #442492 is a reply to message #442491] Mon, 08 February 2010 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it does not.

Regards
Michel
Re: Changing column order using Data Pump in Oracle 10g? [message #442493 is a reply to message #442488] Mon, 08 February 2010 09:10 Go to previous message
AbhijitDey
Messages: 3
Registered: June 2009
Junior Member
Thanks Michel.

Best Regards,
Abhijit
Previous Topic: SOLRJ Loadjava Classes into Database
Next Topic: Cloning the DB
Goto Forum:
  


Current Time: Mon Dec 05 02:51:13 CST 2016

Total time taken to generate the page: 0.17010 seconds