JD Edwards oracle create new schemas owners and tablespaces

Just say you want to create a new copy of control tables for some reason, that could be any reason…  Testing some new menus (wait if you still use menus or tasks, you’re not on the right track – ONLY E1pages should be used for JDE navigation).

Anyway, it’s nice to remember how to run your oracle commands for getting this done.  This is an example on 11G with windoze.

CREATE SMALLFILE TABLESPACE "FBACTLI" DATAFILE 'D:\ORACLE\ORADATA\BROWNES\FBACTLI.DBF' SIZE 1000M AUTOEXTEND ON NEXT 1000K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "FBACTLT" DATAFILE 'D:\ORACLE\ORADATA\BROWNES\FBACTLT.DBF' SIZE 1000M AUTOEXTEND ON NEXT 1000K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

 

-- USER SQL
CREATE USER FBACTL
DEFAULT TABLESPACE FBACTLT
TEMPORARY TABLESPACE TEMP
identified by HelloPass ;

-- ROLES
GRANT “JDE_ROLE” to FBACTL ;

-- SYSTEM PRIVILEGES

-- QUOTAS
ALTER USER FBACTL QUOTA UNLIMITED ON FBACTLT;
ALTER USER FBACTL QUOTA UNLIMITED ON FBACTLI;

You then create a new data source and make sure that you set up the owner to have the correct tablespace defined.  This is from the data source application (gh9011 –> data sources) P986115, choose you data source

Then enter the tablespaces for the indexes and tables (note that I’m creating two at the moment, so the screen shot might be for FIACTL)

You’ll then be good to go to copy things into the new schema.