|
Нестыковка в структуре таблиц
#39251423
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
Вот так:
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.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
Connected to Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
Connected as tst@...
SQL> desc CLIENT_CONTACT
Name Type Nullable Default Comments
--------------- ------------------ -------- ------------ ------------------------------------------------------------
CONTACT_ID NUMBER(10) Идентификатор записи
CONTACT_TYPE NUMBER Y Тип контакта
CONTACT_SUBTYPE NUMBER Y Подтип контакта
ADDRESSEE VARCHAR2(150 CHAR) Y Адресат
MESSAGE CLOB Y Сообщение
RESULT NUMBER Y Результат контакта
ACT_DATE DATE Y sysdate Дата контакта
DESCRIPTION VARCHAR2(250 CHAR) Y Коментарий
CHN_TIME TIMESTAMP(6) Y systimestamp Дата изменения
SQL> select dbms_metadata.get_ddl('TABLE', 'CLIENT_CONTACT') from dual;
DBMS_METADATA.GET_DDL('TABLE',
--------------------------------------------------------------------------------
CREATE TABLE "TST"."CLIENT_CONTACT"
( "CONTACT_ID" NUMBER(10,0),
"CONTACT_TYPE" NUMBER,
"CONTACT_SUBTYPE" NUMBER,
"ADDRESSEE" VARCHAR2(150 CHAR),
"MESSAGE" CLOB,
"RESULT" NUMBER,
"ACT_DATE" DATE DEFAULT sysdate,
"DESCRIPTION" VARCHAR2(250 CHAR),
"CHN_TIME" TIMESTAMP (6) DEFAULT systimestamp,
CHECK ("CONTACT_ID" IS NOT NULL) DISABLE,
CHECK ("CONTACT_TYPE" IS NOT NULL) DISABLE,
CHECK ("CONTACT_SUBTYPE" IS NOT NULL) DISABLE,
CHECK ("ADDRESSEE" IS NOT NULL) DISABLE,
CHECK ("ACT_DATE" IS NOT NULL) DISABLE,
CONSTRAINT "CONTACT_PK" PRIMARY KEY ("CONTACT_ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 2621440 NEXT 262144 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DEV" ENABLE,
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DEV"
LOB ("MESSAGE") STORE AS SECUREFILE (
TABLESPACE "DEV" ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
SQL> select u.constraint_name, u.search_condition, u.status from user_constraints u where table_name = 'CLIENT_CONTACT';
CONSTRAINT_NAME SEARCH_CONDITION STATUS
-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------
SYS_C0018381 "CONTACT_ID" IS NOT NULL DISABLED
SYS_C0018382 "CONTACT_TYPE" IS NOT NULL DISABLED
SYS_C0018383 "CONTACT_SUBTYPE" IS NOT NULL DISABLED
SYS_C0018384 "ADDRESSEE" IS NOT NULL DISABLED
SYS_C0018385 "BANK_CODE" IS NOT NULL DISABLED
SYS_C0018386 "ACT_DATE" IS NOT NULL DISABLED
CONTACT_PK ENABLED
7 rows selected
SQL>
|
|
|
