antoine_mpo
Reputable Poster
Hi List,
I'm working on a way to make full generation during the day, while people are working.
I created a set of F989998 and F989999 tables in another data source, and an ocm mapping for a particular user to use those tables.
I can then make my full html generation.
But my problem is when i want to copy those tables to the "real" tables used by end-users.
When i'm trying to copy them by JDE copy process, i get the following Oracle Error : "ORA-01631: max # extents (505) reached in table DV7333.F989999"
It's because in JDE copy process, JDE first drop the table, then re-create it, so it's no use to change the maxextents parameter on the table ! And i don't know where is took that parameter of 505 max extents !
Any idea ?
For the moment i'm using R98403 report, in "append" mode to work around the issue, but it's taking too much time !
The other solution would be to export/import the table, but i found it a pain in the ass.
Any idea would be appreciated.
How do you do yourself ?
Thansk for your help.
Cheers,
I'm working on a way to make full generation during the day, while people are working.
I created a set of F989998 and F989999 tables in another data source, and an ocm mapping for a particular user to use those tables.
I can then make my full html generation.
But my problem is when i want to copy those tables to the "real" tables used by end-users.
When i'm trying to copy them by JDE copy process, i get the following Oracle Error : "ORA-01631: max # extents (505) reached in table DV7333.F989999"
It's because in JDE copy process, JDE first drop the table, then re-create it, so it's no use to change the maxextents parameter on the table ! And i don't know where is took that parameter of 505 max extents !
Any idea ?
For the moment i'm using R98403 report, in "append" mode to work around the issue, but it's taking too much time !
The other solution would be to export/import the table, but i found it a pain in the ass.
Any idea would be appreciated.
How do you do yourself ?
Thansk for your help.
Cheers,