質問編集履歴
1
CREATE TABLEをキャプチャーからコードに修正しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -110,7 +110,28 @@
|
|
|
110
110
|
### DB情報
|
|
111
111
|
|
|
112
112
|
### 対象テーブル
|
|
113
|
+
```ここに言語を入力
|
|
114
|
+
CREATE TABLE "STUDYUSER"."TODO_LIST_USER"
|
|
115
|
+
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
|
|
116
|
+
"NAME" VARCHAR2(20 BYTE),
|
|
117
|
+
"MAILADDRESS" VARCHAR2(20 BYTE),
|
|
118
|
+
"MAILADDRESSVERIFIED" NUMBER(*,0),
|
|
119
|
+
"PASSWORD" VARCHAR2(1000 BYTE),
|
|
120
|
+
"ENABLED" NUMBER(*,0),
|
|
121
|
+
CONSTRAINT "TODO_LIST_USER_PK" PRIMARY KEY ("ID")
|
|
122
|
+
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
|
|
123
|
+
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
124
|
+
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
|
125
|
+
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
|
126
|
+
TABLESPACE "USERS" ENABLE
|
|
127
|
+
) SEGMENT CREATION IMMEDIATE
|
|
113
|
-
|
|
128
|
+
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
|
|
129
|
+
NOCOMPRESS LOGGING
|
|
130
|
+
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
131
|
+
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
|
|
132
|
+
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
|
|
133
|
+
TABLESPACE "USERS" ;
|
|
134
|
+
```
|
|
114
135
|
### sequence
|
|
115
136
|
|
|
116
137
|
|