All,

I have a table with an xmltype column and a BLOB column in it. I need to restructure this table and add an additional column. There is data that we need to keep in the table.

What is the best method? Also, need to back it up beforehand. Thanks

Original table: I changed a few column names.

F_ID_PK NOT NULL NUMBER(11)
G_ID_FK NOT NULL NUMBER(11)
FAC_ID NOT NULL NUMBER(11)
SOME_ID -- Need to add this column (some_id) here NOT NULL NUMBER(11)
ID_FLAG_NY NOT NULL VARCHAR2(1)
CREATED_BY NOT NULL VARCHAR2(50)
CREATED_DATE NOT NULL DATE
UPDATED_BY VARCHAR2(50)
UPDATED_DATE DATE
EXPIRED_BY VARCHAR2(50)
EXPIRED_DATE DATE
BLOB_COLUMN_NAME BLOB
FOLLOW_UP_COMPLETED_DATE DATE
FOLLOW_UP_COMPLETED_BY VARCHAR2(50)
PROOF_COMPLETED_DATE DATE
PROOF_COMPLETED_BY VARCHAR2(50)
TRACKING_XML SYS.XMLTYPE(XMLSchema "http:
//name.nn.ggg/schemas/name
/trackingschema" Element "TR
ACKING") STORAGE Object-rela
tional TYPE "TRACKING697_T"