NC6X安装-Oracle数据库安装-2_06_创建nc基础表空间-NC技术顾问资料.docx

创建nc基础表空间CREATETABLESPACENNC_DATA01DATAFILE'/home/oracle/app/oradata/nnc_data01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_INDEX01DATAFILE'/home/oracle/app/oradata/nnc_index01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATEUSERNC65IDENTIFIEDBYNC65DEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;GRANTconnect,dbatoNC65;ALTERDATABASETEMPFILE'/home/oracle/app/oradata/orcl/temp01.dbf'AUTOEXTENDONNEXT256MMAXSIZE10240M;