Доступно с лицензией Production Mapping.
В соответствии со стандартными рекомендациями ГИС по хранению файлы журналов и индексов предпочтительно хранить отдельно от векторных и табличных бизнес-таблиц. В целях повышения производительности предпочтительней располагать бизнес-таблицы, таблицы объектов и пространственного индекса раздельно, а файлы данных табличного пространства – в соответствии с шаблоном их применения. В мультиверсионных базах геоданных с высокой активностью работы файлы баз данных табличного пространства VERSIONS могут быть разделены и рассредоточены по доступным дискам, что позволяет уменьшить риски возникновения конфликтов на входе/выходе.
Create new tablespaces to store the ArcGIS 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 | CONFIGURATION_KEYWORD |
|---|---|---|
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 |
The following script can be used to create tablespaces using Oracle SQL Plus or Oracle SQL Developer:
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';
Установите начальный размер файлов данных в 10 МБ, чтобы табличные области создавались бы без задержек. Затем можно изменить размер файлов данных во избежание фрагментации.
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 that the data files and tablespaces have been created.