[ОТВЕТИТЬ]
Опции темы
14.06.2011 15:09  
Mtirt
Если я правильно помню, то у генератора БД лог есть. Можно его увидеть?
 
15.06.2011 06:55  
VitorJ
Я бы с радостью да чтот найти его не могу.
 
15.06.2011 12:26  
Mtirt
Давай попробуем сделать
Код:
describe SVLOCALSHOPS;
describe SVPRODGOODSART;
В базе магазина и в ЦО и сравнить результаты.
 
15.06.2011 13:34  
VitorJ
В базе ЦО
Код:
SQL> describe supermag.SVLOCALSHOPS;
имя                                       пусто?   тип
 ----------------------------------------- -------- ---------------------
 ID                                        NOT NULL NUMBER(10)
 NAME                                      NOT NULL VARCHAR2(255)
 IDCLASS                                   NOT NULL NUMBER(10)
 ACCEPTED                                  NOT NULL CHAR(1)
 PRTY                                      NOT NULL NUMBER(5)
 FLAGS                                     NOT NULL NUMBER(10)
 LOCTYPE                                   NOT NULL NUMBER(5)
 PARENTLOC                                          NUMBER(10)
 RGNID                                     NOT NULL NUMBER(10)
 ADDRESS                                            VARCHAR2(255)
 TEL                                                VARCHAR2(40)
 FAX                                                VARCHAR2(40)
 COMMENTARY                                         VARCHAR2(255)
 ORDERALG                                  NOT NULL VARCHAR2(255)
 CARDTYPE                                           NUMBER(10)
 FORMATID                                           NUMBER(10)
 PRICINGMETHOD                             NOT NULL NUMBER(5)
 SUGGESTORDERALG                           NOT NULL VARCHAR2(50)
 FLOORSPACE                                         NUMBER(14,4)
 GLN                                                VARCHAR2(13)

SQL> describe supermag.SVPRODGOODSART;
 имя                                       пусто?   тип
 ----------------------------------------- -------- ---------------
 STORELOC                                  NOT NULL NUMBER(10)
 ID                                        NOT NULL NUMBER(10)
 ARTICLE                                   NOT NULL VARCHAR2(50)
 QUANTITY                                  NOT NULL NUMBER(14,3)
 NAME                                               VARCHAR2(255)
 UNITNAME                                           VARCHAR2(20)
 INCOMINGQUANTITY                          NOT NULL NUMBER(14,3)
 ISSUEQUANTITY                             NOT NULL NUMBER(14,3)
 AVAILABLEQUANTITY                                  NUMBER
 RETURNQUANTITY                            NOT NULL NUMBER(14,3)
 WASTEQUANTITY                                      NUMBER
 
15.06.2011 13:36  
VitorJ
База магазина
Код:
SQL> describe supermag.SVLOCALSHOPS;
имя                                       пусто?   тип
 ----------------------------------------- -------- ----------------
 ID                                        NOT NULL NUMBER(10)
 NAME                                      NOT NULL VARCHAR2(255)
 IDCLASS                                   NOT NULL NUMBER(10)
 ACCEPTED                                  NOT NULL CHAR(1)
 PRTY                                      NOT NULL NUMBER(5)
 FLAGS                                     NOT NULL NUMBER(10)
 LOCTYPE                                   NOT NULL NUMBER(5)
 PARENTLOC                                          NUMBER(10)
 RGNID                                     NOT NULL NUMBER(10)
 ADDRESS                                            VARCHAR2(255)
 TEL                                                VARCHAR2(40)
 FAX                                                VARCHAR2(40)
 COMMENTARY                                         VARCHAR2(255)
 ORDERALG                                  NOT NULL VARCHAR2(255)
 CARDTYPE                                           NUMBER(10)
 FORMATID                                           NUMBER(10)
 PRICINGMETHOD                             NOT NULL NUMBER(5)
 SUGGESTORDERALG                           NOT NULL VARCHAR2(50)
 FLOORSPACE                                         NUMBER(14,4)
 GLN                                                VARCHAR2(13)


SQL> describe supermag.SVPRODGOODSART;
 имя                                       пусто?   тип
 ----------------------------------------- -------- ----------------------------
 STORELOC                                  NOT NULL NUMBER(10)
 ID                                        NOT NULL NUMBER(10)
 ARTICLE                                   NOT NULL VARCHAR2(50)
 QUANTITY                                  NOT NULL NUMBER(14,3)
 NAME                                               VARCHAR2(255)
 UNITNAME                                           VARCHAR2(20)
 INCOMINGQUANTITY                          NOT NULL NUMBER(14,3)
 ISSUEQUANTITY                             NOT NULL NUMBER(14,3)
 AVAILABLEQUANTITY                                  NUMBER
 RETURNQUANTITY                            NOT NULL NUMBER(14,3)
 WASTEQUANTITY                                      NUMBER
 
15.06.2011 13:37  
VitorJ
ВРоде как одинаково..
 
15.06.2011 13:43  
Mtirt
Код:
select * from all_constraints t where t.constraint_name='SYS_C0011218'
Ну и аналогично для SYS_C0011219 ...
 
16.06.2011 05:07  
VitorJ
В базе ЦО
Код:
SQL> select * from all_constraints t where t.constraint_name='SYS_C0011218';

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SUPERMAG                       SYS_C0011218                   O

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SVLOCALSHOPS

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------


OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
                                                                        ENABLED

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
NOT DEFERRABLE IMMEDIATE NOT VALIDATED GENERATED NAME          06.04.10

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------


OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------


OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
 
16.06.2011 05:11  
VitorJ
Код:
SQL>  select * from all_constraints t where t.constraint_name='SYS_C0011219';

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SUPERMAG                       SYS_C0011219                   O

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SVPRODGOODSART

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------


OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
                                                                        ENABLED

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
NOT DEFERRABLE IMMEDIATE NOT VALIDATED GENERATED NAME          06.04.10

OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------


OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------


OWNER                          CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER                        R_CONSTRAINT_NAME              DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER                    INDEX_NAME                     INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
 
16.06.2011 05:13  
VitorJ
В базе магазина
Код:
SQL> select * from all_constraints t where t.constraint_name='SYS_C0011218';

строки не выбраны

SQL>  select * from all_constraints t where t.constraint_name='SYS_C0011219';

строки не выбраны
 
 


Опции темы



Часовой пояс GMT +3, время: 03:22.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.