1同义词的基表删除对同义词的影响
create table tabletest (col1 varchar2(10),col2 varchar2(10));
create or replace synonym STEST
for user.TABLETEST;
SQL> select * from stest;
COL1 COL2
---------- ----------
SQL> drop table tabletest;
Table dropped
SQL> select * from stest;
select * from stest
ORA-00980: 同义词转换不再有效
此时候只是同义词不能用但该同义词依然存在如果重新创建基表则该同义词可继续使用。
2只读表空间的测试
SQL> create tablespace userdate datafile 'D:/oracle/oradata/orcl/userdate01.dbf'
size 100m;
alter user usertest default tablespace userdate;
--登陆usertest
create table test_tb01 as select * from tabletest;
SQL> select table_name,tablespace_name from user_all_tables;
TABLE_NAME TABLESPACE_NAME
------------------------------ ----------------------------
TEST_TB01 USERDATE
-- 注销usertest 登陆到sys
alter tablespace userdate read only;
--登陆duanjw
SQL> create table test_tb02 as select * from test_tb01;
create table test_tb02 as select * from test_tb01
ORA-01647: 表空间'USERDATE'是只读,无法在其中分配空间
--表空间只读不能作新表的建立
SQL> drop table test_tb01;
Table dropped
--只读表空间中对象仍然可以删除