常用oracle操作语句

CREATE TABLESPACE dcip DATAFILE 'F:\tablespaceswin7\dcip.ora' SIZE 50M AUTOEXTEND ON NEXT 10M;
drop user dcip cascade;
create user dcip identified by dcip default tablespace dcip;
grant connect,resource,dba to dcip;

exp ORC/ORC@GMHISDB file=C:\Users\Administrator\Desktop\dcip.dmp  tables=(SCSJ_ELECTRICITYDATA,scsj_electricitydevice,dmis_dispatchlog_jhjxjl_edit,dmis_dispatchlog_qxjl_edit,dmis_dispatchlog_tcjl_edit,dmis_dispatchlog_tzjl_edit)
imp dcip/dcip@orcl full=y log=F:\tablespaceswin7\log.txt file=


CREATE TABLESPACE megadyccb DATAFILE 'd:\tablespace\megadyccb.ora' SIZE 50M AUTOEXTEND ON NEXT 10M;
drop user megadyccb cascade;
create user megadyccb identified by megadyccb default tablespace megadyccb;
grant connect,resource,dba to megadyccb;

exp ORC/ORC@gmhisdb file=d:\reg_objinfo.ora tables=(reg_objinfo)
imp ORC/ORC@ORC  tables=(reg_objinfo) file=

create table reg_objinfo_bak as select * from reg_objinfo

linux:

CREATE TABLESPACE megaccbnj DATAFILE '/opt/oracle/oradata/mega/megaccbnj.ora' SIZE 50M AUTOEXTEND ON NEXT 10M;
drop user megaccbls cascade;
create user megaccbls identified by megaccbls default tablespace megaccbls;
grant connect,resource,dba to megaccbls;
/opt/oracle/product/10.2.0/bin/imp megaccbls/megaccbls log=/usr/nisd/log.log full=y file=/mnt/dmp/expmegaccbls-16_08_28.dmp
/opt/oracle/product/10.2.0/bin/imp megaccbls/megaccbls log=/usr/nisd/log.log fromuser=megaccbls touser=megaccbls ignore=y file=/mnt/dmp/expmegaccbls-16_08_28.dmp

CREATE TABLESPACE megaccbls DATAFILE 'd:\tablespace\megaccbls.ora' SIZE 50M AUTOEXTEND ON NEXT 100M;
alter tablespace megaccb add datafile 'F:\tablespaceswin7\megaccb2.ora' size 50M AUTOEXTEND ON NEXT 100M;

drop user nisd cascade;
create user nisd identified by nisd default tablespace nisd;
grant connect,resource,dba to nisd;
imp megadyccb/megadyccb@orcl full=y log=D:\tablespace\log.txt file=
imp nisd/megagw@orcl log=F:\tablespaceswin7\log.txt fromuser=megaeyes touser=megagw tablespaces=megagw ignore=y  file=

drop tablespace megagw including contents and datafiles cascade constraints;

CREATE TABLESPACE megaccbls DATAFILE '/opt/oracle/oradata/mega/megaccbls.ora' SIZE 50M AUTOEXTEND ON NEXT 10M;
drop user megaccbls cascade;
create user megaccbls identified by megaccbls default tablespace megaccbls;
grant connect,resource,dba to megaccbls;
imp megaccbls/megaccbls@orcl full=y log=D:\tablespace\log.txt file=
/opt/oracle/product/10.2.0/bin/imp megacx/megacx log=/usr/nisd/megacx.log full=y file=/usr/nisd/

/opt/oracle/product/10.2.0/bin/exp megaccbls/megaccbls file=/usr/nisd/useropt.dmp log=/usr/nisd/log.log tables=(USER_OPERATION_LOG)
/opt/oracle/product/10.2.0/bin/exp megaeyes/megaeyes file=/usr/nisd/backup/`date '+%Y%m%d%H%M%S'`.dmp log=/usr/nisd/backup/`date '+%Y%m%d%H%M%S'`.log
/opt/oracle/product/10.2.0/bin/imp nisd/nisd file=/usr/nisd/useropt.dmp log=/usr/nisd/log.log full=y
/opt/oracle/product/10.2.0/bin/imp nisd/nisd file=/mnt/dmp/expmegaccbls-16_08_28.dmp log=/mnt/dmp/log.log fromuser=megaeyes touser=megals ignore=y buffer=10240000;

/opt/oracle/product/10.2.0/bin/exp megaeyes/megaeyes file=/usr/nisd/megagw.dmp log=/usr/nisd/log.log


sh /usr/nisd/shelltest.sh
lsnrctl start;