お前の悲しみは僕には切望

oracle_bas테이블스페이스를 만들고 bestakas의 디폴트 테이블스페이스를 oracle_bas로 전 포스팅에 주었다.
그럼 이제..~ 테이블을 만들어보자..

CD관련 테이블을 간단히 만들어본다.. sqlplus에서 해당아이디로 접속후,..!를 치고 셀상으로 빠져나와 vi 파일명.sql을 작성한다..

/************************************************************ 테이블명 : music 내용 : 음원기록 ************************************************************/ create table MUSIC (                        EMPNO varchar2(05) NOT NULL,                        TITLE varchar2(100) NOT NULL,                        FILENAME varchar2(100),                        SINGER varchar2(12),                        COPYRIGHT varchar2(12),                        directory varchar2(100),                        NATION varchar2(2),                     CONSTRAINT PK_MUSIC PRIMARY KEY(EMPNO)  );

다시 exit하여 sqlplus로 들어가서..

[oracle@AkasLinux ~]$ exit exit SQL> @misc.sql Table created. SQL> select * from tabs; TABLE_NAME                     TABLESPACE_NAME ------------------------------ ------------------------------ CLUSTER_NAME                   IOT_NAME                       STATUS ------------------------------ ------------------------------ --------   PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT ---------- ---------- ---------- ---------- -------------- ----------- MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS FREELIST_GROUPS LOG B   NUM_ROWS ----------- ----------- ------------ ---------- --------------- --- - ----------     BLOCKS EMPTY_BLOCKS  AVG_SPACE  CHAIN_CNT AVG_ROW_LEN ---------- ------------ ---------- ---------- ----------- AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS ------------------------- ------------------- DEGREE ---------------------------------------- INSTANCES                                CACHE                TABLE_LO ---------------------------------------- -------------------- -------- SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NES BUFFER_ ROW_MOVE GLO USE ----------- --------- --- ------------ - - --- ------- -------- --- --- DURATION        SKIP_COR MON CLUSTER_OWNER                  DEPENDEN COMPRESS --------------- -------- --- ------------------------------ -------- -------- COMPRESS_FOR       DRO REA ------------------ --- --- MUSIC                          ORACLE_BAS TABLE_NAME                     TABLESPACE_NAME ------------------------------ ------------------------------ CLUSTER_NAME                   IOT_NAME                       STATUS ------------------------------ ------------------------------ --------   PCT_FREE   PCT_USED  INI_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT

테이블을 좀 보니..주저리 주저리 뭔말들이 나온다..

오라클 SQL Developer로 확인하여 보자..
정상적으로 테이블이 생성됨을 알수있다.

의도한대로 원하는 테이블스페이스에 테이블이 생성되었다.. ㅋ..

Oracle SQL Developer는
 /home/oracle/oracle11/product/11.1.0/db_1/sqldeveloper에 위치한다.
다음 포스팅은 JDBC를 구성하고..
php와 jsp를 통해서 오라클 쿼리를 이용하여 웹상에서 직접 데이타를 넣어보자...
오늘은 배고프므로.. 여기서 고만... 밥줄인 서버맹글기 일하러 갑니다.

간단하다..아주..
외부에서 vi나 gedit로 SQL문을 작성해서

SQL> @파일명

해주면 끝...

지금보는 Oracle교재가 순전히 정통 SQL문으로만 서술하네...ㅋ
 

오라클을 부팅시 자동시동하니..
리눅스 머신이 너무 무거워지는듯 하다.
그래서 데탑용 리눅스 머신에서 자동시동기능을 없애고...
오라클 계정으로만 오라클을 만질때 써야긋다.

/home/oracle/oracle11/product/11.1.0/db_1/bin/emctl start dbconsole /home/oracle/oracle11/product/11.1.0/db_1/bin/lsnrctl start /home/oracle/oracle11/product/11.1.0/db_1/bin/sqlplus "/as sysdba" SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 23 17:04:01 2009 Copyright (c) 1982, 2007, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area  849530880 bytes Fixed Size                  1303216 bytes Variable Size             461376848 bytes Database Buffers          381681664 bytes Redo Buffers                5169152 bytes Database mounted. Database opened. SQL>

[oracle@AkasLinux emd]$ sqlplus SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 23 15:20:00 2009 Copyright (c) 1982, 2007, Oracle.  All rights reserved. Enter user-name: system Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> create tablespace oracle_bas datafile '/home/oracle/oracle11/oradata/orcl/bas.dbf' size 10M; Tablespace created. SQL> create user bestakas identified by password default tablespace oracle_bas; User created. SQL> grant connect, resource to bestakas; Grant succeeded. SQL> connect bestakas/password Connected. SQL>

Let's Go Oracle

[oracle@AkasLinux bin]$ sqlplus "/ as sysdba" SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 23 14:32:51 2009 Copyright (c) 1982, 2007, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show user USER is "SYS" SQL> alter user sys identified by password; User altered. SQL> alter user system identified by password; User altered. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@AkasLinux bin]$ sqlplus SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 23 14:34:33 2009 Copyright (c) 1982, 2007, Oracle.  All rights reserved. Enter user-name: system Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>

확인 끝