ArcGIS Help 10.2 - Creating data files for the Production Mapping workspace in Oracle (Production Mapping)

Standard GIS storage recommendations favor keeping index and log files separate from vector and tabular business tables. For performance reasons, it is better to position the business, feature, and spatial index tables separately and position tablespace data files based on their usage pattern. For a multiversioned, highly active editing geodatabase, database files of the VERSIONS tablespace may be separated and dispersed across available disks to avoid input/output contention.

Create new tablespaces to store the Esri Production Mapping workspace feature classes and tables.

The following table lists the tablespaces that are going to be created in the SQL example.

TABLESPACE	DATAFILE_NAME	ArcSDE_PARAMETER
PM_BDATA	PM_Bdata	Business table
PM_BINDEX	PM_Bindex	Business table index
PM_FDATA	PM_Fdata	ST_Geometry LOB storage
PM_FINDEX	PM_Findex	ST_Geometry LOB index
PM_SDATA	PM_Sdata	Spatial index tables
PM_SINDEX	PM_Sindex	Spatial index features
PM_ADATA	PM_Adata	Adds table (versioned)
PM_AINDEX	PM_Aindex	Adds table index
PM_DDATA	PM_Ddata	Delete table (versioned)
PM_DINDEX	PM_Dindex	Delete table index
PM_RASTER	PM_Raster	Raster datasets
PM_RINDEX	PM_Rindex	Raster indexes
PM_RBLK	PM_Rblk	Raster BLK table
PM_RBLKIDX	PM_Rblkidx	Raster BLK table indexes
PM_XMLDOC	PM_Xmldoc	XML documents
PM_XMLIDX	PM_Xmlidx	XML documents indexes
PM_TOPO_BDATA	PM_Topo_Bdata	Topology business table
PM_TOPO_BINDEX	PM_Topo_Bindex	Topology business table index
PM_TOPO_FDATA	PM_Topo_Fdata	Topology ST_Geometry Lob storage
PM_TOPO_FINDEX	PM_Topo_Findex	Topology ST_Geometry Lob index
PM_TOPO_SDATA	PM_Topo_SData	Topology spatial index tables
PM_TOPO_SINDEX	PM_Topo_Sindex	Topology spatial index features
PM_TERRAIN_BDATA	PM_Terrain_Bdata	Terrain business table
PM_TERRAIN_BINDEX	PM_Terrain_Bindex	Terrain business table index
PM_TERRAIN_FDATA	PM_Terrain_Fdata	Terrain ST_Geometry LOB storage
PM_TERRAIN_FINDEX	PM_Terrain_Findex	Terrain ST_Geometry LOB index
PM_TERRAIN_SDATA	PM_Terrain_Sdata	Terrain spatial index tables
PM_TERRAIN_SINDEX	PM_Terrain_Sindex	Terrain spatial index features
PM_NET_BDATA	PM_Net_Bdata	Network business table
PM_NET_BINDEX	PM_Net_Bindex	Network business table index
PM_NET_FDATA	PM_Net_Fdata	Network ST_Geometry LOB storage
PM_NET_FINDEX	PM_Net_Findex	Network ST_Geometry LOB index
PM_NET_SDATA	PM_Net_Sdata	Network spatial index tables
PM_NET_SINDEX	PM_Net_Sindex	Network spatial index features

Tablespaces created in the Production Mapping workspace

The following script can be used to create tablespaces using Oracle SQL Plus or Oracle SQL Developer

Note:

Copying and pasting the example may cause syntax errors.

ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "pmadmin";

CREATE SMALLFILE TABLESPACE "PM_BDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_BDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_BINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_BINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_FDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_FDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_FINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_FINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_SDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_SDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_SINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_SINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_ADATA"
DATAFILE 'D:\oradata\MCS\PM\PM_ADATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_AINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_AINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_DDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_DDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_DINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_DINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_XMLDOC"
DATAFILE 'D:\oradata\MCS\PM\PM_XMLDOC01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_XMLIDX"
DATAFILE 'D:\oradata\MCS\PM\PM_XMLIDX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

--TOPOLOGY
CREATE SMALLFILE TABLESPACE "PM_TOPO_BDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_TOPO_BDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TOPO_BINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_TOPO_BINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TOPO_FDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_TOPO_FDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TOPO_FINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_TOPO_FINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TOPO_SDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_TOPO_SDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TOPO_SINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_TOPO_SINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

--TERRAIN
CREATE SMALLFILE TABLESPACE "PM_TERRAIN_BDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_TERRAIN_BDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TERRAIN_BINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_TERRAIN_BINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TERRAIN_FDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_TERRAIN_FDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TERRAIN_FINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_TERRAIN_FINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TERRAIN_SDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_TERRAIN_SDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_TERRAIN_SINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_TERRAIN_SINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

--NETWORK
CREATE SMALLFILE TABLESPACE "PM_NET_BDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_NET_BDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_NET_BINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_NET_BINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_NET_FDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_NET_FDATA01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_NET_FINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_NET_FINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M 
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_NET_SDATA"
DATAFILE 'D:\oradata\MCS\PM\PM_NET_SDATA01.dbf'SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_NET_SINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_NET_SINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE 400M
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_RASTER"
DATAFILE 'D:\oradata\MCS\PM\PM_RASTER01.dbf' SIZE 10M AUTOEXTEND ON NEXT 4M MAXSIZE 800M
BLOCKSIZE 8k
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_RINDEX"
DATAFILE 'D:\oradata\MCS\PM\PM_RINDEX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 4M MAXSIZE 800M 
BLOCKSIZE 8K
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_RBLK"
DATAFILE 'D:\oradata\MCS\PM\PM_RBLK01.dbf' SIZE 10M AUTOEXTEND ON NEXT 4M MAXSIZE 8G 
BLOCKSIZE 8k
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

CREATE SMALLFILE TABLESPACE "PM_RBLKIDX"
DATAFILE 'D:\oradata\MCS\PM\PM_RBLKIDX01.dbf' SIZE 10M AUTOEXTEND ON NEXT 4M MAXSIZE 800M 
BLOCKSIZE 8K
LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K 
SEGMENT SPACE MANAGEMENT AUTO
DEFAULT COMPRESS FOR OLTP STORAGE ( ENCRYPT ) ENCRYPTION USING 'AES256';

Set the data files’ initial size to 10 MB so there is no delay in the creation of the tablespaces. You can then resize the data files to avoid fragmentation.

ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Bdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Bindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Fdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Findex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Sdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Sindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Adata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Aindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Ddata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Dindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Xmldoc01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Xmlidx01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Raster01.dbf' RESIZE 800M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Rindex01.dbf' RESIZE 800M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Rblk01.dbf' RESIZE 2G;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Rblkidx01.dbf' RESIZE 800M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Topo_Bdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Topo_Bindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Topo_Fdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Topo_Findex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Topo_Sdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Topo_Sindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Terrain_Bdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Terrain_Bindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Terrain_Fdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Terrain_Findex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Terrain_Sdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Terrain_Sindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Net_Bdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Net_Bindex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Net_Fdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Net_Findex01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Net_Sdata01.dbf' RESIZE 400M;
ALTER DATABASE DATAFILE 'D:\ORADATA\MCS\pm\pm_Net_Sindex01.dbf' RESIZE 400M;

You can use Oracle Enterprise Manager to verify the data files and tablespaces have been created.

6/8/2015