Oracle表空间脚本Oracle参考脚本用户创建ORACLE数据库最高权限的脚本如下。可以根据需求，修改参数大小。酌情创建所需目录。用户创建ORACLE数据库最低权限的脚本如下。CREATETABLESPACENNC_DATA01DATAFILE'D:\ORACLE\ORADATA\ORA11G\nnc_data01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_INDEX01DATAFILE'D:\ORACLE\ORADATA\ORA11G\nnc_index01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;grantconnect,createtable,createview,unlimitedtablespace,createproceduretouap65;grantselectonv_$reserved_wordstouap65;grantselectonuser_tablestouap65;grantcreatesequencetouap65;ORACLE临时表空间要求ALTERDATABASETEMPFILE'/ufsoft/ordata/oradata/ora92/temp01.dbf'AUTOEXTENDONNEXT256MMAXSIZE10240M;CREATETABLESPACENNC_DATA01DATAFILE'D:\ORACLE\ORADATA\ORA11G\nnc_data01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_INDEX01DATAFILE'D:\ORACLE\ORADATA\ORA11G\nnc_index01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATEUSERUAP65IDENTIFIEDBYUAP65DEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;GRANTconnect,dbatoUAP65;
