-
Notifications
You must be signed in to change notification settings - Fork 0
/
USDT.sql
39 lines (33 loc) · 1 KB
/
USDT.sql
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
32
33
34
35
36
37
38
39
ALTER TABLE RISHAL.USER_DETAILS
DROP PRIMARY KEY CASCADE;
DROP TABLE RISHAL.USER_DETAILS CASCADE CONSTRAINTS;
CREATE TABLE RISHAL.USER_DETAILS
(
USER_NAME VARCHAR2(30 BYTE),
USER_ID VARCHAR2(15 BYTE) NOT NULL,
USER_PASSWORD VARCHAR2(12 BYTE),
LAST_LOGIN_TIME DATE
)
DROP SYNONYM RISHAL.USDT;
CREATE OR REPLACE SYNONYM RISHAL.USDT FOR RISHAL.USER_DETAILS;
ALTER TABLE RISHAL.USER_DETAILS ADD (
PRIMARY KEY
(USER_NAME)
USING INDEX
TABLESPACE SYSTEM
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
ENABLE VALIDATE);