Table Archiving in Oracle 10g database

[Former Member]

Hi Friends,

We are facing performance problem and large size of tables like FAGLFLEXA, BALDAT etc.

Now we want to archive the tables, please help us and if any one has done this activity please share it.

In particular we want to archive tables ACCTIT, ACCTHD, ACCTCR. We are using ECC6.0 and HP_UX11i v2 and oracle 10g

Regards

Ganesh Datt Tiwari

Edited by: tiwari.ganeshdatt on Feb 2, 2011 7:19 AM

[Former Member]

Hi,

Please check this note: Note 48009 - Tables ACCTHD, ACCTIT, ACCTCR: Questions and answers

Point 6 about archiving of these tables...

Kind regards,

Mark

[Former Member]

Hi Mark,

Thanks for your valuable help.

I have read that note its very helpfull.

Can we do it online or all the users should be locked and documents stored in this tables should be closed ?

Regrads

Ganesh Datt Tiwari

[Former Member]

Archiving can always be done online. Just use the correct archiving objects.

Kind regards,

Mark

[Former Member]

Hi Mark,

I have archived the tables. It is archived but not stored.

Files are accessable but I m not getting the archived doc in activated infostructure relted to object MM_ACCTIT.

After writte action we have to run Deleted action ?

Please help me.

Regards

Ganesh Datt Tiwari

[Former Member]

I know only the basics of archiving, I'm not an expert in this area... I would check the documentation thoroughly before deleting anything.

Kind regards,

Mark