Oracle - 备份数据库表

Oracle - 备份数据库表

1.备份employees表到employees_bck

create table employees_bck
as --必须写
select * from employees;

2.创建employees_bck2表，复制employees表结构(不要数据)

create table employees_bck2
as
select * from employees 
where 1=2;

3.使用employees表中的某几列创建employees_test表

create table employees_test
(id,fullname,hire_date,salary)
as
select employee_id,first_name||last_name,hire_date,salary
from employees;

4.从其他表拷贝数据

insert into employees_bck2(employee_id,first_name,last_name)
select employee_id,first_name,last_name from employees;