流程自己整理的Word格式文档下载.docx

流程自己整理的Word格式文档下载.docx

《流程自己整理的Word格式文档下载.docx》由会员分享，可在线阅读，更多相关《流程自己整理的Word格式文档下载.docx（13页珍藏版）》请在冰点文库上搜索。

SYS"

一、首先创建自己的工作路径文件夹：

oracle@rzsidb3#/:

ls

BMCINSTALLccichomemboxsbinsoftwareunix

TT_DBchownimage.datamntscriptstftpbootusr

auditdevliboptsmit.logtivolivar

binesalost+foundoraclesmit.scripttmp

bosinst.dataetclppprocsmit.transactionu

cdccic

oracle@rzsidb3#/ccic:

1_11713_715441432.dbfafiedt.buflost+foundwujifeng

2_1478_715441432.dbfligangtangenning

mkdirliancheng

1_11713_715441432.dbfafiedt.bufligangtangenning

2_1478_715441432.dbflianchenglost+foundwujifeng

cdliancheng

oracle@rzsidb3#/ccic/liancheng:

ls-l

total0

mkdirscripts

cdscripts

oracle@rzsidb3#/ccic/liancheng/scripts:

二、在AIX上通过FTP命令将Oracle脚本上传至自己的工作文件夹下

ls-ltr

drwxr-xr-x2oracleoinstall256May1714:

05scripts

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.

cd

?

Invalidcommand

drw-rw-rw-1usergroup0May1714:

26OracleScripts

cdOracleScripts

250Directorychangedto/OracleScripts

pwd

257"

/OracleScripts"

iscurrentdirectory.

-rw-rw-rw-1usergroup2193May1709:

5622147_CREATE_TABLE_FOR_ORACLE.sql

mget*.sql

mget22147_CREATE_TABLE_FOR_ORACLE.sql?

y

150OpeningASCIImodedataconnectionfor22147_CREATE_TABLE_FOR_ORACLE.sql（2193Bytes）.

2193bytesreceivedin5.6e-05seconds（3.824e+04Kbytes/s）

local:

22147_CREATE_TABLE_FOR_ORACLE.sqlremote:

22147_CREATE_TABLE_FOR_ORACLE.sql

bye

221Goodbye!

total8

-rw-r--r--1oracleoinstall2142May1714:

3322147_CREATE_TABLE_FOR_ORACLE.sql

三、确认该脚本是否正确（表空间等）

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）

CREATEINDEXIX_IMGENTRY_RELNOONDST_IMG_ORI_ENTRY（REL_NO）

CREATETABLEDST_EXG_ORI_ENTRY

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）

CREATEINDEXIX_EXGENTRY_RELNOONDST_EXG_ORI_ENTRY（REL_NO）

commit;

~

:

q!

四、在Oracle中创建用户，并在这个用户下创建这张表（即新创建表的拥有者为该新创建的用户）

!

pwd

/ccic/liancheng/scripts

createuserlianchengidentifiedbylalaladefaulttablespaceRED_IDX;

Usercreated.

grantconnect,resourcetoliancheng;

Grantsucceeded.

exit

--==============================================================

sqlplusliancheng

Release10.2.0.4.0-ProductiononTueMay1714:

51:

392011

Enterpassword:

showsuer

SP2-0158:

unknownSHOWoption"

showuser;

LIANCHENG"

more22147_CREATE_TABLE_FOR_ORACLE.sql

spoolNo1.log

ls-ltr

ls:

0653-341Thefile-doesnotexist.

0653-341Thefileltrdoesnotexist.

-rw-r--r--1oracleoinstall0May1714:

54No1.log

@22147_CREATE_TABLE_FOR_ORACLE.sql

Tablecreated.

Tablealtered.

Indexcreated.

Commitcomplete.

五、最后进行检查确认：

setlinesize500;

setpagesize200;

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

2whereowner='

LIANCHENG'

LIANCHENGDST_EXG_ORI_ENTRYRED_DAT

关闭spool，检查刚才生成的日志文件：

spooloff

notspoolingcurrently

moreNo1.log

^[[Ccz

SP2-0042:

unknowncommand"

^[[Ccz"

-restoflineignored.

dddd^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[