Oracle11g-NC63创建表空间及用户及授权

Oracle11gNC63创建表空间及用户及授权在cmd中运行sqlplus/nologconn/assysdba2--建表空间及用户CREATETABLESPACENNC_DATA01DATAFILE'F:\app\oradata\nnc_data01.dbf'SIZE2048MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_DATA02DATAFILE'F:\app\oradata\nnc_data02.dbf'SIZE50MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_DATA03DATAFILE'F:\app\oradata\nnc_data03.dbf'SIZE2048MAUTOEXTENDONNEXT100MEXTENTMANAGEMENTLOCALUNIFORMSIZE512K;CREATETABLESPACENNC_INDEX01DATAFILE'F:\app\oradata\nnc_index01.dbf'SIZE100MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATETABLESPACENNC_INDEX02DATAFILE'F:\app\oradata\nnc_index02.dbf'SIZE2048MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATETABLESPACENNC_INDEX03DATAFILE'F:\app\oradata\nnc_index03.dbf'SIZE100MAUTOEXTENDONNEXT100MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;3--创建用户及授权:CREATEUSERnc63IDENTIFIEDBYnc63DEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;4--给用户授权（GRANTconnect,dbatonc63;）