Search Posts

DBA

Tablespace creation

CREATE TABLESPACE GBD DATAFILE ‘E:\app\oracle\oracle\oradata\orcl\GBD01.DBF’

SIZE 2G AUTOEXTEND ON NEXT 128M MAXSIZE 16G EXTENT MANAGEMENT LOCAL AUTOALLOCATE

SEGMENT SPACE MANAGEMENT AUTO;

 

 

CREATE TABLESPACE ENABLEMENT DATAFILE ‘E:\app\oracle\oracle\oradata\orcl\ENABLEMENT01.DBF’

SIZE 2G AUTOEXTEND ON NEXT 128M MAXSIZE 16G EXTENT MANAGEMENT LOCAL AUTOALLOCATE

SEGMENT SPACE MANAGEMENT AUTO;

 

 

CREATE TABLESPACE GBDIDX DATAFILE ‘E:\app\oracle\oracle\oradata\orcl\GBDIDX01.DBF’

SIZE 1G AUTOEXTEND ON NEXT 128M MAXSIZE 16G EXTENT MANAGEMENT LOCAL AUTOALLOCATE

SEGMENT SPACE MANAGEMENT AUTO;

 

 

CREATE TABLESPACE ENABLEMENTIDX DATAFILE ‘E:\app\oracle\oracle\oradata\orcl\ENABLEMENTIDX01.DBF’

SIZE 1G AUTOEXTEND ON NEXT 128M MAXSIZE 16G EXTENT MANAGEMENT LOCAL AUTOALLOCATE

SEGMENT SPACE MANAGEMENT AUTO;

 

 

User creation

CREATE USER gbdDatamart80 IDENTIFIED BY manoj123

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE “TEMP”

PROFILE DEFAULT

ACCOUNT UNLOCK;

 

 

GRANT CONNECT TO gbdDatamart80;

GRANT RESOURCE TO gbdDatamart80;

GRANT CREATE ANY VIEW TO gbdDatamart80;

 

 

alter user gbdDatamart80  quota unlimited on USERS;

 

 

drop user EcEnablement cascade;

CREATE USER EcEnablement IDENTIFIED BY manoj123

DEFAULT TABLESPACE ENABLEMENT

TEMPORARY TABLESPACE “TEMP”

PROFILE DEFAULT

ACCOUNT UNLOCK;

 

GRANT CONNECT TO EcEnablement;

GRANT RESOURCE TO EcEnablement;

GRANT CREATE ANY VIEW TO EcEnablement;

 

alter user EcEnablement  quota unlimited on ENABLEMENT;

alter user EcEnablement  quota unlimited on ENABLEMENTIDX;