请问下面这句话是什么意思?
If you create a public synonym and it subsequently has dependent tables or dependent valid user-defined object types, then you cannot subsequently create another database object of the same name as the synonym in the same schema as the dependent objects.
我做的实验,似乎和描述的不符啊:
17:37:39 SQL> CREATE PUBLIC SYNONYM SYN_PUB_ILONNG_T1 FOR T1;
Synonym created.
Elapsed: 00:00:00.02
17:37:49 SQL> CREATE TABLE SYN_PUB_ILONNG_T1 ( A NUMBER);
Table created.
Elapsed: 00:00:00.03
最初由 ilonng 发布
[B]请问下面这句话是什么意思?
If you create a public synonym and it subsequently has dependent tables or dependent valid user-defined object types, then you cannot subsequently create another database object of the same name as the synonym in the same schema as the dependent objects.
我做的实验,似乎和描述的不符啊:
17:37:39 SQL> CREATE PUBLIC SYNONYM SYN_PUB_ILONNG_T1 FOR T1;
Synonym created.
Elapsed: 00:00:00.02
17:37:49 SQL> CREATE TABLE SYN_PUB_ILONNG_T1 ( A NUMBER);
Table created.
Elapsed: 00:00:00.03 [/B]
[PHP]
SQL> conn test/test@ora11g
已连接。
SQL> create or replace type t_type is table of varchar2(30);
2/
类型已创建。
SQL> conn yangtk/yangtk@ora11g
已连接。
SQL> create or replace public synonym t_type for test.t_type;
同义词已创建。
SQL> create table t_type (id number);
表已创建。
SQL> drop table t_type;
表已删除。
SQL> create table t_tab (id number, name t_type) nested table name store as t_tab_date;
表已创建。
SQL> create table t_type (id number);
create table t_type (id number)
最初由 yangtingkun 发布
[B]
[PHP]
SQL> conn test/test@ora11g
已连接。
SQL> create or replace type t_type is table of varchar2(30);
2/
类型已创建。
SQL> conn yangtk/yangtk@ora11g
已连接。
SQL> create or replace public synonym t_type for test.t_type;
同义词已创建。
SQL> create table t_type (id number);
表已创建。
SQL> drop table t_type;
表已删除。
SQL> create table t_tab (id number, name t_type) nested table name store as t_tab_date;
表已创建。
SQL> create table t_type (id number);
create table t_type (id number)