ORACLE常见问题

1、两张表之间复制数据

insert into table2 select * from table1;
如果表不存在可以使用
create table table2 as select * from table1;

 2、oracle帐户密码忘记

sqlplus / as sysdba;

alter user system identified by oracle;

如果此时登陆帐户锁定，输入解锁帐户命令：

alter user system account unlock;

3、创建用户及设置表空间

create tablespace TBS_JBOA
logging  
datafile 'D:\software\product\18.0.0\oradata\XE\jboa_data.dbf' 
size 10m  
autoextend on  
next 10m maxsize 2048m  
extent management local;

--18c xe创建用户及设置表空间
CREATE USER userjboa  IDENTIFIED BY userjboa;
ALTER USER userjboa DEFAULT ROLE ALL;
ALTER USER userjboa DEFAULT TABLESPACE TBS_JBOA;
ALTER USER userjboa QUOTA UNLIMITED ON TBS_JBOA;
GRANT CONNECT,RESOURCE TO userjboa;
GRANT create table to userjboa;
GRANT create trigger to userjboa;