Alcalde
Active Member
Re: Issue while copying Serialized object tables (F989998, F989999) (max
Hi,
Why don't you make a simply import. The only detail you have to remember is
to grant privilege to *public after the import procedure.
Related the error you are receiving. Have you really checked that the table
is recreate or it just delete records?
antoine_mpo
<[email protected] To: [email protected]
> cc:
Sent by: Subject: Issue while copying Serialized object tables (F989998, F989999) (max extents
jdelist-bounces@j reached)
delist.com
12/07/2004 15:09
Please respond to
"PeopleSoft®
EnterpriseOne"
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,
Antoine. OW system Administrator OneWorld Xe, Update 6, SP20 One-Off R1
Windows Servers (NT and 2000) Oracle 8i Databases Websphere 4 on JAS
servers
The entire JDELIST thread is available for viewing.
This is the JDELIST Applications Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing
list are available here.
JDELIST is not affiliated with JDEdwards®.
The information transmitted is intended only for the person(s)or entity
to which it is addressed and may contain confidential and/or legally
privileged material. Delivery of this message to any person other than
the intended recipient(s) is not intended in any way to waive privilege
or confidentiality. Any review, retransmission, dissemination or other
use of, or taking of any action in reliance upon, this information by
entities other than the intended recipient is prohibited. If you
receive this in error, please contact the sender and delete the
material from any computer.
For Translation:
http://www.baxter.com/email_disclaimer
Hi,
Why don't you make a simply import. The only detail you have to remember is
to grant privilege to *public after the import procedure.
Related the error you are receiving. Have you really checked that the table
is recreate or it just delete records?
antoine_mpo
<[email protected] To: [email protected]
> cc:
Sent by: Subject: Issue while copying Serialized object tables (F989998, F989999) (max extents
jdelist-bounces@j reached)
delist.com
12/07/2004 15:09
Please respond to
"PeopleSoft®
EnterpriseOne"
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,
Antoine. OW system Administrator OneWorld Xe, Update 6, SP20 One-Off R1
Windows Servers (NT and 2000) Oracle 8i Databases Websphere 4 on JAS
servers
The entire JDELIST thread is available for viewing.
This is the JDELIST Applications Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing
list are available here.
JDELIST is not affiliated with JDEdwards®.
The information transmitted is intended only for the person(s)or entity
to which it is addressed and may contain confidential and/or legally
privileged material. Delivery of this message to any person other than
the intended recipient(s) is not intended in any way to waive privilege
or confidentiality. Any review, retransmission, dissemination or other
use of, or taking of any action in reliance upon, this information by
entities other than the intended recipient is prohibited. If you
receive this in error, please contact the sender and delete the
material from any computer.
For Translation:
http://www.baxter.com/email_disclaimer