CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Create Custome table

edited Apr 12, 2017 5:00AM in CNC, DB and Operating System - JDE1 (MOSC) 5 commentsAnswered

Hi,

    

I create custom table from OMW, my doubt:

1_what is the SQL statement build and send from JDE to DB layer?  I means it's standard SQL statement to create all basic, custom tables from JDE?

2_and it's create with "autoextend turn on"?  or after create DBA turn flag = on from DB...?   and what happend with priv?

old table say:

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

but notice new table create today say:

STORAGE( PCTINCREASE 0)

      

thanks in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center