PRODUCT_USER_PROFILE
SQL> conn sky/apspass@sdb
Connected.
SQL> insert into PRODUCT_USER_PROFILE (
2 product, userid, attribute, char_value)
3 values (
4 'SQL*Plus','SKY','CREATE','DISABLED');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> create table bb(x int);
Table created.
SQL> drop table bb;
Table dropped.
SQL> create table bb(x int);
Table created.
SQL> drop table bb;
Table dropped.
SQL> conn sky/apspass@sdb
Connected.
SQL> create table bb(x int);
SP2-0544: invalid command: create
SQL> select count(*) from PRODUCT_USER_PROFILE;
COUNT(*)
----------
1
SQL> delete from PRODUCT_USER_PROFILE
2 where user_id='SKY';
where user_id='SKY'
*
ERROR at line 2:
ORA-00904: invalid column name
SQL> ed
Wrote file afiedt.buf
1 delete from PRODUCT_USER_PROFILE
2* where userid='SKY'
SQL> /
1 row deleted.
SQL> commit;
Commit complete.
SQL> create table xx(bb int);
SP2-0544: invalid command: create
SQL> conn sky/apspass@sdb
Connected.
SQL> create table xx(bb int);
Table created.
SQL> drop table xx;
Table dropped.
SQL>
http://www.oracle.com.cn/viewthread.php?tid=86599
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch10.htm#1005767
Posted by Sky at 05:29 PM | Permalink | comments(0) | Edit | Database