修改表空间名
alter tablespace name1 rename to name2;
修改表名
alter table name1 rename to name2;
修改表中字段名
alter table table_name rename column column_1 to column_2;
查询所有的表空间
select * from v$tablespace;
查询所有用户
select * from DBA_USERS;
SELECT * FROM ALL_USERS;
查询用户所关联的表
select username,default_tablespace from dba_users;
查看当前用户的表:
select table_name from user_tables;
创建表空间/创建用户/赋予管理员权限
create tablespace criseszone datafile 'D:/oracle10/orcl/criseszone.dbf' size 100m autoextend on next 50m maxsize unlimited;
create user crises identified by crises default tablespace criseszone;
grant connect,resource,dba to crises;
删除表空间/删除用户
DROP TABLESPACE criseszone INCLUDING CONTENTS AND DATAFILES;
drop user crises cascade;
导出
>cd\
>exp username/password@192.168.1.125/orcl file=E:/name.dmp
导入
>cd\
>imp username/password@192.168.1.125/orcl file=D:/name.dmp full=y ignore=y
添加:
列:alter table AirTicket add (Discount double (8,2) default (10.0) );
string型Varchar2(50)
例:alter table EEMS_T_ACCIDENT_REPORT_ add (ACC_NUM_ Varchar2(50));