Hi all,
I have two tables which were initially created to hold temp data. When those two tables were created, we did not define any of the max extents size.
Today, the business requirements have changed and we are adding more data into those two tables more than ever before. As a result, I am getting the following error messages:
ORA-01631: max # extents (100) reached in table XXXXXXX
What I am trying to do is to Export the data from those two tables, drop them, create new tables with the pre-defined extents and then import the data back onto the new tables. Could someone please help me with these steps.
I was reading some materials on the net and there were so many suggestions which confused me. I would like to ensure that when the new tables are created, I won't lose any data. All the components of the tables are exported and then imported back in.
Thanks....
I have two tables which were initially created to hold temp data. When those two tables were created, we did not define any of the max extents size.
Today, the business requirements have changed and we are adding more data into those two tables more than ever before. As a result, I am getting the following error messages:
ORA-01631: max # extents (100) reached in table XXXXXXX
What I am trying to do is to Export the data from those two tables, drop them, create new tables with the pre-defined extents and then import the data back onto the new tables. Could someone please help me with these steps.
I was reading some materials on the net and there were so many suggestions which confused me. I would like to ensure that when the new tables are created, I won't lose any data. All the components of the tables are exported and then imported back in.
Thanks....