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;