'분류 전체보기' 카테고리의 글 목록 (19 Page)

일	월	화	수	목	금	토
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31

sqlplus copy 명령어

2010. 1. 29. 12:05 Database관련/Oracle

COPY FROM scott/tiger@oracle CREATE emp2 USING select * FROM emp;

***** SQLPLUS에서 수행할 SQL 문장1 (RDB => ORACLE)

COPY FROM HGLEE/RDBMANIA@ODBC:RDB70 TO SCOTT/TIGER@ORA71 -
INSERT ORA_TAB(O1,O2) USING SELECT R1,R2 FROM RDB_TAB;

(설명)
HGLEE/RDBMANIA : RDB가 위치한 노드의 OS 사용자/암호
RDB70 : RDB 데이타베이스를 억세스하기 위한 ODBC data source name
SCOTT/TIGER : ORACLE 데이타베이스 사용자/암호
ORA71 : ORACLE 데이타베이스를 억세스하기 위한 SQL*Net connect string

***** SQLPLUS에서 수행할 SQL 문장2 (ORACLE => RDB)

COPY FROM SCOTT/TIGER@ORA71 TO HGLEE/RDBMANIA@ODBC:RDB70 -
INSERT RDB_TAB(R1,R2) USING SELECT O1,O2 FROM ORA_TAB WHERE O1=40;

[출처] SqlPlus에서 Oracle-Rdb 간의 데이타 주고받기(Odbc 이용)|작성자 늘푸지

'Database관련 > Oracle' 카테고리의 다른 글

테이블 스페이스/사용자 생성및 삭제 (0)	2011.01.20
sql xml로 바꿔서 출력 쿼리 (0)	2010.02.03
export,import 명령어 (0)	2010.01.29
tablespace,user,grant,sequence 생성 (0)	2010.01.29
toad 접속방법 (0)	2010.01.29

posted by 천상의날개

export,import 명령어

2010. 1. 29. 12:04 Database관련/Oracle

EXP userID/userPassWord@tnsnames.ora서비스네임 FILE='C:\aa.dmp' INDEXES=Y ROWS=Y CONSTRAINTS=Y TRIGGERS=Y COMPRESS=Y GRANTS=Y DIRECT=N CONSISTENT=N STATISTICS=ESTIMATE TABLES=(table1,table2,table3)

imp userID/userPassWord@tnsnames.ora 서비스네임 file='C:\aa.dmp' fromuser='ecolett' tables=(table1,table2,table3)

'Database관련 > Oracle' 카테고리의 다른 글

sql xml로 바꿔서 출력 쿼리 (0)	2010.02.03
sqlplus copy 명령어 (0)	2010.01.29
tablespace,user,grant,sequence 생성 (0)	2010.01.29
toad 접속방법 (0)	2010.01.29
기본키 변경 (0)	2010.01.29

posted by 천상의날개

tablespace,user,grant,sequence 생성

2010. 1. 29. 12:04 Database관련/Oracle

create tablespace memp datafile 'c:\memp.ora' size 50m autoextend on;

create user memp identified by memp default tablespace memp;

grant connect,resource to memp;

conn memp/memp;

create sequence order_seq start with 1 increment by 1;

'Database관련 > Oracle' 카테고리의 다른 글

sqlplus copy 명령어 (0)	2010.01.29
export,import 명령어 (0)	2010.01.29
toad 접속방법 (0)	2010.01.29
기본키 변경 (0)	2010.01.29
em복구방법 (0)	2010.01.29

posted by 천상의날개

toad 접속방법

2010. 1. 29. 12:03 Database관련/Oracle

(ORACLE_HOME)network\ADMIN 안에

TNSNAMES.ORA 파일에 다음과 같이 셋팅~~

A1=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
      (SRVR = DEDICATED)
    )
)

A1이 접속할 이름 ORCL 은 SID

붉은색만 바꿔주면됨....

'Database관련 > Oracle' 카테고리의 다른 글

export,import 명령어 (0)	2010.01.29
tablespace,user,grant,sequence 생성 (0)	2010.01.29
기본키 변경 (0)	2010.01.29
em복구방법 (0)	2010.01.29
DB 수동생성 (0)	2010.01.29

posted by 천상의날개

기본키 변경

2010. 1. 29. 12:02 Database관련/Oracle

1.먼저 primary key를 drop하세요.
-> alter table 테이블명 drop primary key;
2.복합key로 다시 primary key를 만드세요.
-> alter table 테이블명 add constraint 인덱스명 primary key(기존컬럼,추가컬럼)
....

혹 primary key가 없었다면, 바로 2번으로 가능하죠.
그러나 primary key가 이미 있다면 곧바로 추가는 안됩니다.

'Database관련 > Oracle' 카테고리의 다른 글

export,import 명령어 (0)	2010.01.29
tablespace,user,grant,sequence 생성 (0)	2010.01.29
toad 접속방법 (0)	2010.01.29
em복구방법 (0)	2010.01.29
DB 수동생성 (0)	2010.01.29

posted by 천상의날개

em복구방법

2010. 1. 29. 12:02 Database관련/Oracle

http://blog.naver.com/hirokorea?Redirect=Log&logNo=20057042187

'Database관련 > Oracle' 카테고리의 다른 글

export,import 명령어 (0)	2010.01.29
tablespace,user,grant,sequence 생성 (0)	2010.01.29
toad 접속방법 (0)	2010.01.29
기본키 변경 (0)	2010.01.29
DB 수동생성 (0)	2010.01.29

posted by 천상의날개

DB 수동생성

2010. 1. 29. 12:02 Database관련/Oracle

Oracle - DB 수동생성

1. 오라클 시드 생성

$ export ORACLE_SID=orcl

2. 파라메터 파일 생성

$ cd $ORACLE_HOME/dbs
$ vi initorcl.ora

    compatible='10.2.0.1.0'
    control_files='/oracle/oradata/orcl/control01.ctl'
    db_block_size=8192
    db_name=orcl
    remote_login_paswordfile='exclusive'
    sga_target=167772160
    undo_management=auto
    undo_tablespace='undotbs'

3. 패스워드 파일 생성

$ cd $ORACLE_HOME/dbs
$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle

4. 데이터 파일 디렉토리 생성

$ cd oracle
$ mkdir -p /oracle/oradata/orcl
$ chown -R oracle.dba /oracle
$ chmod 755 /oracle/oradata

5. 오라클 인스턴트 노마운트 옵션으로 실행

$ echo $ORACLE_SID
    -> 시드가 orcl 맞는지 확인한다.
$ sqlplus / as sysdba
SQL> startup nomount

6. create database 명령 실행

SQL> create database orcl
            controlfile reuse
             logfile
                 group 1 (‘/oracle/oradata/orcl/redo01a.rdo’) size 10m reuse,
                 group 2 (‘/oracle/oradata/orcl/redo02a.rdo’) size 10m reuse
             datafile ‘/oracle/oradata/orcl/system01.dbf’ size 50m reuse
                 autoextend on
             sysaux
             datafile ‘/oracle/oradata/orcl/sysaux01.dbf’ size 50m reuse
                 autoextend on
             undo tablespace undotbs
             datafile ‘/oracle/oradata/orcl/undotbs01.dbf’ size 50m reuse
                 autoextend on
             default temporary tablespace temp
             tempfile ‘/oracle/oradata/orcl/temp01.dbf’ size 50m reuse
                 autoextend on;

7. 딕셔너리 생성 및 빌트인 펑션 및 패키지 생성(sys 계정으로 수행)

SQL> show user
    ->유저가 sys인지 확인
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc
    -> ?는 $ORACLE_HOME

8. 사용자가 접속할 때마다 경고 메시지를 부리지 않기 위해 pupbld.sql 실행

SQL> @?/sqlplus/admin/pupbld.sql

9. 과정 중 에러 발생 시에는 alert log file 확인

$ cd $ORACLE_HOME/rdbms/log
$ vi alertorcl.ora

'Database관련 > Oracle' 카테고리의 다른 글

export,import 명령어 (0)	2010.01.29
tablespace,user,grant,sequence 생성 (0)	2010.01.29
toad 접속방법 (0)	2010.01.29
기본키 변경 (0)	2010.01.29
em복구방법 (0)	2010.01.29

posted by 천상의날개

자식창에서 부모창 함수 실행

2010. 1. 29. 11:54 JavaScript

textMain.html (부모창)

<html>
                                                <head>
                <script type="text/javascript">if (!window.T) { window.T = {} }
window.T.config = {"TOP_SSL_URL":"https://www.tistory.com","PREVIEW":false,"ROLE":"guest","PREV_PAGE":"","NEXT_PAGE":"","BLOG":{"id":500884,"name":"jbluewing","title":"하늘을향해","isDormancy":false,"nickName":"천상의날개","status":"open","profileStatus":"normal"},"NEED_COMMENT_LOGIN":false,"COMMENT_LOGIN_CONFIRM_MESSAGE":"","LOGIN_URL":"https://www.tistory.com/auth/login/?redirectUrl=https://jbluewing.tistory.com/category","DEFAULT_URL":"https://jbluewing.tistory.com","USER":{"name":null,"homepage":null,"id":0,"profileImage":null},"SUBSCRIPTION":{"status":"none","isConnected":false,"isPending":false,"isWait":false,"isProcessing":false,"isNone":true},"IS_LOGIN":false,"HAS_BLOG":false,"IS_SUPPORT":false,"IS_SCRAPABLE":false,"TOP_URL":"http://www.tistory.com","JOIN_URL":"https://www.tistory.com/member/join","PHASE":"prod","ROLE_GROUP":"visitor"};
window.T.entryInfo = null;
window.appInfo = {"domain":"tistory.com","topUrl":"https://www.tistory.com","loginUrl":"https://www.tistory.com/auth/login","logoutUrl":"https://www.tistory.com/auth/logout"};
window.initData = {};

window.TistoryBlog = {
    basePath: "",
    url: "https://jbluewing.tistory.com",
    tistoryUrl: "https://jbluewing.tistory.com",
    manageUrl: "https://jbluewing.tistory.com/manage",
    token: "3/hOIcFL8z5wXSsSYKCTJhG/TFq2Y4ambd349iOmCN2vmaDMF+Ue6nrNltCZbOlY"
};
var servicePath = "";
var blogURL = "";</script>

.another_category h4 {
    font-size: 12px !important;
    margin: 0 !important;
    border-bottom: 1px solid #E5E5E5 !important;
    padding: 2px 0 6px !important;
}

.another_category h4 a {
    font-weight: bold !important;
}

.another_category table {
    table-layout: fixed;
    border-collapse: collapse;
    width: 100% !important;
    margin-top: 10px !important;
}

* html .another_category table {
    width: auto !important;
}

*:first-child + html .another_category table {
    width: auto !important;
}

.another_category th, .another_category td {
    padding: 0 0 4px !important;
}

.another_category th {
    text-align: left;
    font-size: 12px !important;
    font-weight: normal;
    word-break: break-all;
    overflow: hidden;
    line-height: 1.5;
}

.another_category td {
    text-align: right;
    width: 80px;
    font-size: 11px;
}

.another_category th a {
    font-weight: normal;
    text-decoration: none;
    border: none !important;
}

.another_category th a.current {
    font-weight: bold;
    text-decoration: none !important;
    border-bottom: 1px solid !important;
}

.another_category th span {
    font-weight: normal;
    text-decoration: none;
    font: 10px Tahoma, Sans-serif;
    border: none !important;
}

.another_category_color_gray, .another_category_color_gray h4 {
    border-color: #E5E5E5 !important;
}

.another_category_color_gray * {
    color: #909090 !important;
}

.another_category_color_gray th a.current {
    border-color: #909090 !important;
}

.another_category_color_gray h4, .another_category_color_gray h4 a {
    color: #737373 !important;
}

.another_category_color_red, .another_category_color_red h4 {
    border-color: #F6D4D3 !important;
}

.another_category_color_red * {
    color: #E86869 !important;
}

.another_category_color_red th a.current {
    border-color: #E86869 !important;
}

.another_category_color_red h4, .another_category_color_red h4 a {
    color: #ED0908 !important;
}

.another_category_color_green, .another_category_color_green h4 {
    border-color: #CCE7C8 !important;
}

.another_category_color_green * {
    color: #64C05B !important;
}

.another_category_color_green th a.current {
    border-color: #64C05B !important;
}

.another_category_color_green h4, .another_category_color_green h4 a {
    color: #3EA731 !important;
}

.another_category_color_blue, .another_category_color_blue h4 {
    border-color: #C8DAF2 !important;
}

.another_category_color_blue * {
    color: #477FD6 !important;
}

.another_category_color_blue th a.current {
    border-color: #477FD6 !important;
}

.another_category_color_blue h4, .another_category_color_blue h4 a {
    color: #1960CA !important;
}

.another_category_color_violet, .another_category_color_violet h4 {
    border-color: #E1CEEC !important;
}

.another_category_color_violet * {
    color: #9D64C5 !important;
}

.another_category_color_violet th a.current {
    border-color: #9D64C5 !important;
}

.another_category_color_violet h4, .another_category_color_violet h4 a {
    color: #7E2CB5 !important;
}
</style>

<script type="application/ld+json">
    {"@context":"http://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":0,"item":{"@id":"https://jbluewing.tistory.com/entry/sqlplus-copy-%EB%AA%85%EB%A0%B9%EC%96%B4","name":"sqlplus copy 명령어"}},{"@type":"ListItem","position":1,"item":{"@id":"https://jbluewing.tistory.com/entry/exportimport-%EB%AA%85%EB%A0%B9%EC%96%B4","name":"export,import 명령어"}},{"@type":"ListItem","position":2,"item":{"@id":"https://jbluewing.tistory.com/entry/tablespaceusergrantsequence-%EC%83%9D%EC%84%B1","name":"tablespace,user,grant,sequence 생성"}},{"@type":"ListItem","position":3,"item":{"@id":"https://jbluewing.tistory.com/entry/toad-%EC%A0%91%EC%86%8D%EB%B0%A9%EB%B2%95","name":"toad 접속방법"}},{"@type":"ListItem","position":4,"item":{"@id":"https://jbluewing.tistory.com/entry/%EA%B8%B0%EB%B3%B8%ED%82%A4-%EB%B3%80%EA%B2%BD","name":"기본키 변경"}},{"@type":"ListItem","position":5,"item":{"@id":"https://jbluewing.tistory.com/entry/em%EB%B3%B5%EA%B5%AC%EB%B0%A9%EB%B2%95","name":"em복구방법"}},{"@type":"ListItem","position":6,"item":{"@id":"https://jbluewing.tistory.com/entry/DB-%EC%88%98%EB%8F%99%EC%83%9D%EC%84%B1","name":"DB 수동생성"}},{"@type":"ListItem","position":7,"item":{"@id":"https://jbluewing.tistory.com/entry/%EC%9E%90%EC%8B%9D%EC%B0%BD%EC%97%90%EC%84%9C-%EB%B6%80%EB%AA%A8%EC%B0%BD-%ED%95%A8%EC%88%98-%EC%8B%A4%ED%96%89","name":"자식창에서 부모창 함수 실행"}},{"@type":"ListItem","position":8,"item":{"@id":"https://jbluewing.tistory.com/entry/popup-post%EB%A1%9C-%EB%84%98%EA%B8%B0%EA%B8%B0","name":"popup post로 넘기기"}},{"@type":"ListItem","position":9,"item":{"@id":"https://jbluewing.tistory.com/entry/label-%ED%85%8D%EC%8A%A4%ED%8A%B8%EB%A5%BC-%EC%B0%8D%EC%9C%BC%EB%A9%B4-checkbox%EB%82%98-radio-%ED%81%B4%EB%A6%AD%EB%90%98%EA%B2%8C-%ED%95%98%EB%8A%94%EA%B2%83","name":"label 텍스트를 찍으면 checkbox나 radio 클릭되게 하는것"}}]}
</script>

<link rel="stylesheet" type="text/css" href="https://tistory1.daumcdn.net/tistory_admin/userblog/userblog-92a0ff29eba69149e99a17fe09aa8e5b3343ff4e/static/style/dialog.css"/>
<link rel="stylesheet" type="text/css" href="//t1.daumcdn.net/tistory_admin/www/style/top/font.css"/>
<link rel="stylesheet" type="text/css" href="https://tistory1.daumcdn.net/tistory_admin/userblog/userblog-92a0ff29eba69149e99a17fe09aa8e5b3343ff4e/static/style/postBtn.css"/>
<link rel="stylesheet" type="text/css" href="https://tistory1.daumcdn.net/tistory_admin/userblog/userblog-92a0ff29eba69149e99a17fe09aa8e5b3343ff4e/static/style/tistory.css"/>
<script type="text/javascript" src="https://tistory1.daumcdn.net/tistory_admin/userblog/userblog-92a0ff29eba69149e99a17fe09aa8e5b3343ff4e/static/script/common.js"></script>

</head>
<body>
<button type=button onclick="popupOpen()">자식창호출</button>
<form name="form">
<input type="text" name="na" style="border:none;"  width="10" disabled="false"/>
</form>

<div style="margin:0; padding:0; border:none; background:none; float:none; clear:none; z-index:0"></div>
<script type="text/javascript" src="https://tistory1.daumcdn.net/tistory_admin/userblog/userblog-92a0ff29eba69149e99a17fe09aa8e5b3343ff4e/static/script/common.js"></script>
<script type="text/javascript">window.roosevelt_params_queue = window.roosevelt_params_queue || [{channel_id: 'dk', channel_label: '{tistory}'}]</script>
<script type="text/javascript" src="//t1.daumcdn.net/midas/rt/dk_bt/roosevelt_dk_bt.js" async="async"></script>

</body>
</html>

aa.html (자식창)