表空间创建及数据泵导入su-oraclesqlplus/assysdbaNC65CREATETABLESPACENNC_DATA01DATAFILE'E:\app\Administrator\oradata\NCDB\NCDBDATA\nnc_data01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_INDEX01DATAFILE'E:\app\Administrator\oradata\NCDB\NCDBDATA\nnc_index01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATEUSERLJLQDB1230IDENTIFIEDBYLJLQDB1230DEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;GRANTconnect,dbatoLJLQDB1230;ALTERDATABASETEMPFILE'E:\app\Administrator\oradata\NCDB\temp01.dbf'AUTOEXTENDONNEXT256MMAXSIZE10240M;数据泵导入CREATEDIRECTORYexpdirAS'E:\expdir';grantread,writeondirectoryexpdirtoLJLQDB1230;impdpLJLQDB1230/LJLQDB1230dumpfile=NC633GOLD.DMPremap_schema=NC633GOLD:LJLQDB1230directory=expdirlogfile=in0.logimpNC633/123file=D:\setup\datafiles\NC633GOLD.DMPfromuser=NC633GOLDtouser=NC633log=in1112.logNC5Xoracle_base/NCDB/u01/app/oracle创建表空间CREATETABLESPACENNC_DATA01DATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_data01.dbf''SIZE1024MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_DATA02DATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_data02.dbf'SIZE1024MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_DATA03DATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_data03.dbf'SIZE1024MAUTOEXTENDONNEXT100MEXTENTMANAGEMENTLOCALUNIFORMSIZE512K;CREATETABLESPACENNC_INDEX01DATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_index01.dbf'SIZE1024MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATETABLESPACENNC_INDEX02DATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_index02.dbf'SIZE1024MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATETABLESPACENNC_INDEX03DATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_index03.dbf'SIZE1024MAUTOEXTENDONNEXT100MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_IUFODATAFILE'/NCDB/u01/app/oracle/oradata/orcl/nnc_iufo.dbf'SIZE1024MAUTOEXTENDONNEXT100MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATEUSERNCUSERIDENTIFIEDBYNCUSERDEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;CREATEUSERIUFOIDENTIFIEDBYiufoDEFAULTTABLESPACENNC_IUFOTEMPORARYTABLESPACEtemp;GRANTconnect,dbatoNCUSER;GRANTconnect,dbatoIUFO;ALTERPROFILEDEFAULTLIMITPASSWORD_LIFE_TIMEUNLIMITED;############ISMCREATETABLESPACENNC_DATA01DATAFILE'D:\oracle\product\10.2.0\oradata\orcl\nnc_data01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_INDEX01DATAFILE'D:\oracle\product\10.2.0\oradata\orcl\nnc_index01.dbf'SIZE500MAUTOEXTENDONNEXT50MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATEUSERismIDENTIFIEDBYismDEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;GRANTconnect,dbatoism;数据泵导入CREATEDIRECTORYdirAS'/NCDB/dir';grantread,writeondirectorydirtoNCUSER;grantread,writeondirectorydirtoiufo;exitimpdpNCUSER/NCUSERdumpfile=NC57GOLD.DMPremap_schema=NC57GOLD:NCUSERdirectory=dpdumpdirlogfile=in.logimpdpiufo/iufodumpfile=NC57iufo.DMPremap_schema=iufo:iufodirectory=dpdumpdirlogfile=in.log导入impNCUSER/NCUSERfile=/NCDB/dir/NCUSER1211evening.dmpfromuser=NCUSERtouser=NCUSERlog=in1211NCUSER.logimpiufo/iufofile=/NCDB/dir/iufo1211evening.dmpfromuser=iufotouser=iufolog=in1211iufo.logdropuserNC633cascade;CREATEUSERNCUSERIDENTIFIEDBYNCUSERDEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;GRANTconnect,dbatoNCUSER;impiufo/iufofile=/NCDB/dir/iufo1211evening.dmpfromuser=iufotouser=iufolog=in1211iufo.logdropuserNC633cascade;
