--创建表空间
create tablespace compsignup2012
logging
datafile 'F:\Oracle\oradata\orcl\compsignup2012.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建用户
create user compsignup2012 identified by "123" default tablespace compsignup2012;
--授予权限
grant connect,resource,dba to compsignup2012;
--删除表空间
DROP TABLESPACE compsignup2012 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
--删除用户
drop user compsignup2012 cascade;
--导入dmp文件:开始-->运行-->
imp zjaccountbackup/"123"@127.0.0.1:1521/orcl file=f:\zjaccountback.dmp full=y
--1. 复制表结构及其数据:
create table table_name_new as select * from table_name_old
--2. 只复制表结构:
create table table_name_new as select * from table_name_old where 1=2;
--或者:
create table table_name_new like table_name_old
--3. 只复制表数据:
--如果两个表结构一样:
insert into table_name_new select * from table_name_old
--如果两个表结构不一样:
insert into table_name_new(column1,column2...) select column1,column2... from table_name_old
create tablespace compsignup2012
logging
datafile 'F:\Oracle\oradata\orcl\compsignup2012.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建用户
create user compsignup2012 identified by "123" default tablespace compsignup2012;
--授予权限
grant connect,resource,dba to compsignup2012;
--删除表空间
DROP TABLESPACE compsignup2012 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
--删除用户
drop user compsignup2012 cascade;
--导入dmp文件:开始-->运行-->
imp zjaccountbackup/"123"@127.0.0.1:1521/orcl file=f:\zjaccountback.dmp full=y
--1. 复制表结构及其数据:
create table table_name_new as select * from table_name_old
--2. 只复制表结构:
create table table_name_new as select * from table_name_old where 1=2;
--或者:
create table table_name_new like table_name_old
--3. 只复制表数据:
--如果两个表结构一样:
insert into table_name_new select * from table_name_old
--如果两个表结构不一样:
insert into table_name_new(column1,column2...) select column1,column2... from table_name_old