连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining optionsSQL> help alter user; ALTER USER ---------- Use this command to change any of the following characteristics of a database user: * authentication mechanism of the user * password * default tablespace for object creation * tablespace for temporary segments created for the user * tablespace access and tablespace quotas * limits on database resources * default roles ALTER USER user { IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'} | DEFAULT TABLESPACE tablespace | TEMPORARY TABLESPACE tablespace | QUOTA { integer [K | M] | UNLIMITED} ON tablespace [ QUOTA { integer [K | M] | UNLIMITED} ON tablespace] ... | PROFILE profile | PASSWORD EXPIRE | ACCOUNT { LOCK | UNLOCK } | DEFAULT ROLE { role [, role] ... | ALL [EXCEPT role [, role] ...] | NONE} } ... For detailed information on this command, see the Oracle8 Server SQL Reference.
add不用加column
如果是drop 就要用到!
alter table abc drop column c
“很全的help.sql Oracle的sqlplus环境下的帮助系统”
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> help alter user; ALTER USER
---------- Use this command to change any of the following characteristics of a
database user: * authentication mechanism of the user
* password
* default tablespace for object creation
* tablespace for temporary segments created for the user
* tablespace access and tablespace quotas
* limits on database resources
* default roles ALTER USER user
{ IDENTIFIED {BY password | EXTERNALLY
| GLOBALLY AS 'CN=user'}
| DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED} ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED} ON tablespace] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK }
| DEFAULT ROLE { role [, role] ...
| ALL [EXCEPT role [, role] ...]
| NONE} } ... For detailed information on this command, see the Oracle8 Server SQL
Reference.