Configuring Oracle Database Tablespaces and User Accounts
The following steps outline the creation of a dedicated tablespace and a corresponding user account within an Oracle database.
-- Create a tablespace named GIS_DATA
CREATE TABLESPACE GIS_DATA
DATAFILE 'C:\ORACLE\DATA\GIS_DATA01.DBF' SIZE 150M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SE ...
Posted on Sat, 08 Aug 2026 16:45:50 +0000 by jude0311