8管理表空间资料.ppt

CREATE SMALLFILE TABLESPACE FIRST DATAFILE C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\firth01.dbf SIZE 10M LOGGING EXTENT MANAGEMENT LOCAL autoallocate SEGMENT SPACE MANAGEMENT AUTO CREATE SMALLFILE TABLESPACE SECOND DATAFILE C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\second01.dbf SIZE 10M AUTOEXTEND ON NEXT 2M MAXSIZE 20M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO CREATE SMALLFILE UNDO TABLESPACE SIX_UNDO DATAFILE C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\six_undo01.dbf SIZE 5M extent management local autoallocate 注意：不可以显示指定uniform size 字句。 ALTER TABLESPACE TEMP ADD TEMPFILE C:\O