Created
December 15, 2011 02:40
-
-
Save seraphy/1479593 to your computer and use it in GitHub Desktop.
ORACLEでテスト用スキーマを作る定型文
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 現在のDBFファイルの一覧 | |
select * | |
from dba_data_files | |
; | |
-- テーブルスペースと、そのデータファイルの作成 | |
create tablespace TS_TEST | |
datafile 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEST.DBF' | |
size 10m | |
autoextend on next 10m maxsize unlimited | |
segment space management auto | |
; | |
-- 一時表領域と、そのデータファイルの作成 | |
create temporary tablespace TS_TEST_TMP | |
tempfile 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TEST_TMP.DBF' | |
size 10m reuse | |
extent management local uniform size 1m | |
; | |
-- ユーザの作成 | |
create user TEST | |
identified by TEST | |
default tablespace TS_TEST | |
temporary tablespace TS_TEST_TMP | |
; | |
-- 接続とリソース使用の権限を付与 | |
grant connect, resource to TEST; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment