Hey!! Sky!

Mar 31, 2006

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


 


Send A Comment