流程自己整理的.docx
- 文档编号:4365263
- 上传时间:2023-05-07
- 格式:DOCX
- 页数:13
- 大小:16.57KB
流程自己整理的.docx
《流程自己整理的.docx》由会员分享,可在线阅读,更多相关《流程自己整理的.docx(13页珍藏版)》请在冰点文库上搜索。
流程自己整理的
oracle@rzsidb3#/home/oracle:
>id
uid=500(oracle)gid=206(oinstall)groups=207(dba),208(hagsuser)
oracle@rzsidb3#/home/oracle:
>sqlplus"/assysdba"
SQL*Plus:
Release10.2.0.4.0-ProductiononTueMay1711:
11:
172011
Copyright(c)1982,2007,Oracle.AllRightsReserved.
Connectedto:
OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0-64bitProduction
WiththePartitioning,RealApplicationClusters,OLAP,DataMining
andRealApplicationTestingoptions
SQL>showuser
USERis"SYS"
SQL>
一、首先创建自己的工作路径文件夹:
oracle@rzsidb3#/:
>ls
BMCINSTALLccichomemboxsbinsoftwareunix
TT_DBchownimage.datamntscriptstftpbootusr
auditdevliboptsmit.logtivolivar
binesalost+foundoraclesmit.scripttmp
bosinst.dataetclppprocsmit.transactionu
oracle@rzsidb3#/:
>cdccic
oracle@rzsidb3#/ccic:
>ls
1_11713_715441432.dbfafiedt.buflost+foundwujifeng
2_1478_715441432.dbfligangtangenning
oracle@rzsidb3#/ccic:
>mkdirliancheng
oracle@rzsidb3#/ccic:
>ls
1_11713_715441432.dbfafiedt.bufligangtangenning
2_1478_715441432.dbflianchenglost+foundwujifeng
oracle@rzsidb3#/ccic:
>cdliancheng
oracle@rzsidb3#/ccic/liancheng:
>ls
oracle@rzsidb3#/ccic/liancheng:
>ls-l
total0
oracle@rzsidb3#/ccic/liancheng:
>mkdirscripts
oracle@rzsidb3#/ccic/liancheng:
>cdscripts
oracle@rzsidb3#/ccic/liancheng/scripts:
>ls
oracle@rzsidb3#/ccic/liancheng/scripts:
>ls-l
total0
二、在AIX上通过FTP命令将Oracle脚本上传至自己的工作文件夹下
oracle@rzsidb3#/ccic/liancheng:
>ls-ltr
total0
drwxr-xr-x2oracleoinstall256May1714:
05scripts
oracle@rzsidb3#/ccic/liancheng:
>cdscripts
oracle@rzsidb3#/ccic/liancheng/scripts:
>ftp10.226.1.41
Connectedto10.226.1.41.
220Serv-UFTPServerv6.3forWinSockready...
Name(10.226.1.41:
oracle):
liancheng
331Usernameokay,needpassword.
Password:
230Userloggedin,proceed.
ftp>ls-ltr
200PORTCommandsuccessful.
150OpeningASCIImodedataconnectionfor/bin/ls.
drw-rw-rw-1usergroup0Sep152009files
drw-rw-rw-1usergroup0Oct292010bak10.226.1.207_101029
drw-rw-rw-1usergroup0Nov82010pssdiag_rgdolap4
drw-rw-rw-1usergroup0Jan1320:
41rzsxpgm1_bak110113
drw-rw-rw-1usergroup0Feb1214:
39bak10.226.1.207
drw-rw-rw-1usergroup0Feb1815:
52Backup
drw-rw-rw-1usergroup0May1215:
32DownloadByCcic
drw-rw-rw-1usergroup0May1308:
56UploadForRtnet
226Transfercomplete.
ftp>cd
?
Invalidcommand
ftp>
?
Invalidcommand
ftp>ls-ltr
200PORTCommandsuccessful.
150OpeningASCIImodedataconnectionfor/bin/ls.
drw-rw-rw-1usergroup0Sep152009files
drw-rw-rw-1usergroup0Oct292010bak10.226.1.207_101029
drw-rw-rw-1usergroup0Nov82010pssdiag_rgdolap4
drw-rw-rw-1usergroup0Jan1320:
41rzsxpgm1_bak110113
drw-rw-rw-1usergroup0Feb1214:
39bak10.226.1.207
drw-rw-rw-1usergroup0Feb1815:
52Backup
drw-rw-rw-1usergroup0May1215:
32DownloadByCcic
drw-rw-rw-1usergroup0May1308:
56UploadForRtnet
drw-rw-rw-1usergroup0May1714:
26OracleScripts
226Transfercomplete.
ftp>cdOracleScripts
250Directorychangedto/OracleScripts
ftp>pwd
257"/OracleScripts"iscurrentdirectory.
ftp>ls-ltr
200PORTCommandsuccessful.
150OpeningASCIImodedataconnectionfor/bin/ls.
-rw-rw-rw-1usergroup2193May1709:
5622147_CREATE_TABLE_FOR_ORACLE.sql
226Transfercomplete.
ftp>mget*.sql
mget22147_CREATE_TABLE_FOR_ORACLE.sql?
y
200PORTCommandsuccessful.
150OpeningASCIImodedataconnectionfor22147_CREATE_TABLE_FOR_ORACLE.sql(2193Bytes).
226Transfercomplete.
2193bytesreceivedin5.6e-05seconds(3.824e+04Kbytes/s)
local:
22147_CREATE_TABLE_FOR_ORACLE.sqlremote:
22147_CREATE_TABLE_FOR_ORACLE.sql
ftp>bye
221Goodbye!
oracle@rzsidb3#/ccic/liancheng/scripts:
>ls-ltr
total8
-rw-r--r--1oracleoinstall2142May1714:
3322147_CREATE_TABLE_FOR_ORACLE.sql
三、确认该脚本是否正确(表空间等)
oracle@rzsidb3#/ccic/liancheng/scripts:
>vi*.sql
ex:
0602-182Historyfilehasnoreadpermission.[Pressreturntocontinue]
"22147_CREATE_TABLE_FOR_ORACLE.sql"[Lastlineisnotcomplete]52lines,2142characters
CREATETABLEDST_IMG_ORI_ENTRY
(
DST_SEQ_NODECIMAL(18,0)NOTNULL,
PRE_NOVARCHAR(17)NOTNULL,
REL_NOVARCHAR(17)NOTNULL,
G_NODECIMAL(19,0)NOTNULL,
ORIGIN_COUNTRYVARCHAR(3)NOTNULL,
ENTRY_IDVARCHAR(18)NOTNULL,
ENTRY_G_NODECIMAL(19,0)NOTNULL,
TRADE_PRICEDECIMAL(19,5),
TRADE_CURRVARCHAR(3),
MODIFY_MARKVARCHAR
(1),
G_QTYDECIMAL(19,5)NULL,
G_UNITVARCHAR(3)NULL
)
tablespaceRED_DAT;
ALTERTABLEDST_IMG_ORI_ENTRYADDCONSTRAINTPK_DST_IMG_ORI_ENTRYPRIMARYKEY(PRE_NO,G_NO,ORIGIN_COUNTRY,ENTRY_ID,ENTRY_G_NO)
usingindextablespaceRED_DAT;
CREATEINDEXIX_IMGENTRY_SEQNOONDST_IMG_ORI_ENTRY(DST_SEQ_NO)
tablespaceRED_DAT;
CREATEINDEXIX_IMGENTRY_RELNOONDST_IMG_ORI_ENTRY(REL_NO)
tablespaceRED_DAT;
CREATETABLEDST_EXG_ORI_ENTRY
(
DST_SEQ_NODECIMAL(18,0)NOTNULL,
PRE_NOVARCHAR(17)NOTNULL,
REL_NOVARCHAR(17)NOTNULL,
G_NODECIMAL(19,0)NOTNULL,
ORIGIN_COUNTRYVARCHAR(3)NOTNULL,
ENTRY_IDVARCHAR(18)NOTNULL,
ENTRY_G_NODECIMAL(19,0)NOTNULL,
TRADE_PRICEDECIMAL(19,5),
TRADE_CURRVARCHAR(3),
MODIFY_MARKVARCHAR
(1),
G_QTYDECIMAL(19,5)NULL,
G_UNITVARCHAR(3)NULL
)
tablespaceRED_DAT;
ALTERTABLEDST_EXG_ORI_ENTRYADDCONSTRAINTPK_DST_EXG_ORI_ENTRYPRIMARYKEY(PRE_NO,G_NO,ORIGIN_COUNTRY,ENTRY_ID,ENTRY_G_NO);
CREATEINDEXIX_EXGENTRY_SEQNOONDST_EXG_ORI_ENTRY(DST_SEQ_NO)
tablespaceRED_DAT;
CREATEINDEXIX_EXGENTRY_RELNOONDST_EXG_ORI_ENTRY(REL_NO)
tablespaceRED_DAT;
commit;
~
~
~
~
~
~
~
~
~
~
~
~
~
~
:
q!
四、在Oracle中创建用户,并在这个用户下创建这张表(即新创建表的拥有者为该新创建的用户)
SQL>!
pwd
/ccic/liancheng/scripts
SQL>!
ls-ltr
total8
-rw-r--r--1oracleoinstall2142May1714:
3322147_CREATE_TABLE_FOR_ORACLE.sql
SQL>createuserlianchengidentifiedbylalaladefaulttablespaceRED_IDX;
Usercreated.
SQL>grantconnect,resourcetoliancheng;
Grantsucceeded.
SQL>exit
--==============================================================
oracle@rzsidb3#/ccic/liancheng/scripts:
>sqlplusliancheng
SQL*Plus:
Release10.2.0.4.0-ProductiononTueMay1714:
51:
392011
Copyright(c)1982,2007,Oracle.AllRightsReserved.
Enterpassword:
Connectedto:
OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0-64bitProduction
WiththePartitioning,RealApplicationClusters,OLAP,DataMining
andRealApplicationTestingoptions
SQL>showsuer
SP2-0158:
unknownSHOWoption"
SQL>showuser;
USERis"LIANCHENG"
SQL>!
pwd
/ccic/liancheng/scripts
SQL>!
ls-ltr
total8
-rw-r--r--1oracleoinstall2142May1714:
3322147_CREATE_TABLE_FOR_ORACLE.sql
SQL>!
more22147_CREATE_TABLE_FOR_ORACLE.sql
CREATETABLEDST_IMG_ORI_ENTRY
(
DST_SEQ_NODECIMAL(18,0)NOTNULL,
PRE_NOVARCHAR(17)NOTNULL,
REL_NOVARCHAR(17)NOTNULL,
G_NODECIMAL(19,0)NOTNULL,
ORIGIN_COUNTRYVARCHAR(3)NOTNULL,
ENTRY_IDVARCHAR(18)NOTNULL,
ENTRY_G_NODECIMAL(19,0)NOTNULL,
TRADE_PRICEDECIMAL(19,5),
TRADE_CURRVARCHAR(3),
MODIFY_MARKVARCHAR
(1),
G_QTYDECIMAL(19,5)NULL,
G_UNITVARCHAR(3)NULL
)
tablespaceRED_DAT;
ALTERTABLEDST_IMG_ORI_ENTRYADDCONSTRAINTPK_DST_IMG_ORI_ENTRYPRIMARYKEY(PRE_NO,G_NO,ORIGIN_COUNTRY,ENTRY_ID,ENTRY_G_NO)
usingindextablespaceRED_DAT;
CREATEINDEXIX_IMGENTRY_SEQNOONDST_IMG_ORI_ENTRY(DST_SEQ_NO)
tablespaceRED_DAT;
CREATEINDEXIX_IMGENTRY_RELNOONDST_IMG_ORI_ENTRY(REL_NO)
tablespaceRED_DAT;
CREATETABLEDST_EXG_ORI_ENTRY
(
DST_SEQ_NODECIMAL(18,0)NOTNULL,
PRE_NOVARCHAR(17)NOTNULL,
REL_NOVARCHAR(17)NOTNULL,
G_NODECIMAL(19,0)NOTNULL,
ORIGIN_COUNTRYVARCHAR(3)NOTNULL,
ENTRY_IDVARCHAR(18)NOTNULL,
ENTRY_G_NODECIMAL(19,0)NOTNULL,
TRADE_PRICEDECIMAL(19,5),
TRADE_CURRVARCHAR(3),
MODIFY_MARKVARCHAR
(1),
G_QTYDECIMAL(19,5)NULL,
G_UNITVARCHAR(3)NULL
)
tablespaceRED_DAT;
ALTERTABLEDST_EXG_ORI_ENTRYADDCONSTRAINTPK_DST_EXG_ORI_ENTRYPRIMARYKEY(PRE_NO,G_NO,ORIGIN_COUNTRY,ENTRY_ID,ENTRY_G_NO);
CREATEINDEXIX_EXGENTRY_SEQNOONDST_EXG_ORI_ENTRY(DST_SEQ_NO)
tablespaceRED_DAT;
CREATEINDEXIX_EXGENTRY_RELNOONDST_EXG_ORI_ENTRY(REL_NO)
tablespaceRED_DAT;
commit;
SQL>spoolNo1.log
SQL>!
ls-ltr
ls:
0653-341Thefile-doesnotexist.
ls:
0653-341Thefileltrdoesnotexist.
SQL>!
ls-ltr
total8
-rw-r--r--1oracleoinstall2142May1714:
3322147_CREATE_TABLE_FOR_ORACLE.sql
-rw-r--r--1oracleoinstall0May1714:
54No1.log
SQL>!
pwd
/ccic/liancheng/scripts
SQL>@22147_CREATE_TABLE_FOR_ORACLE.sql
Tablecreated.
Tablealtered.
Indexcreated.
Indexcreated.
Tablecreated.
Tablealtered.
Indexcreated.
Indexcreated.
Commitcomplete.
五、最后进行检查确认:
SQL>setlinesize500;
SQL>setpagesize200;
SQL>selectowner,table_name,tablespace_namefromdba_tables
2wheretable_namelike'%DST_IMG%';
OWNERTABLE_NAMETABLESPACE_NAME
------------------------------------------------------------------------------------------
ALLSYSDST_IMGRED_DAT
ALLSYSDST_IMG_ORI_ENTRYRED_DAT
WUJIFENGDST_IMG_ORI_ENTRYRED_DAT
LIANCHENGDST_IMG_ORI_ENTRYRED_DAT
SQL>selectowner,table_name,tablespace_namefromdba_tables
2whereowner='LIANCHENG';
OWNERTABLE_NAMETABLESPACE_NAME
------------------------------------------------------------------------------------------
LIANCHENGDST_IMG_ORI_ENTRYRED_DAT
LIANCHENGDST_EXG_ORI_ENTRYRED_DAT
SQL>
关闭spool,检查刚才生成的日志文件:
SQL>spooloff
notspoolingcurrently
SQL>!
moreNo1.log
SQL>!
ls-ltr
SQL>!
ls-ltr
SQL>!
pwd
SQL>@22147_CREATE_TABLE_FOR_ORACLE.sql
Tablecreated.
Tablealtered.
Indexcreated.
Indexcreated.
Tablecreated.
Tablealtered.
Indexcreated.
Indexcreated.
Commitcomplete.
SQL>
SQL>^[[Ccz
SP2-0042:
unknowncommand"^[[Ccz"-restoflineignored.
SQL>dddd^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 流程 自己 整理