Schema and User
Schema and User
Schema is the whole sum of objects that a user has created.
A user needs to be added when there was new work process is added in a company.
1. Default tablespace needs to be created CREATE TABLESPACE name DATAFILE ‘file name’ SIZE # [ M | G ] CREATE TABLESPACE NAME DATAFILE ‘file name’ SIZE # [ M | G ]
2. Temporary Tablespace needs to be assigned CREATE TEMPORARY TABLESPACE name TEMPFI…
View On WordPress










