orcle command

最新推荐文章于 2023-09-22 09:14:37 发布

Bulain

最新推荐文章于 2023-09-22 09:14:37 发布

阅读量86

点赞数

分类专栏： database study

database study 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

orcle command

sqlplus system@dbtest_10.240.13.67
select sid,serial#, status from v$session where username='username';
alter system kill session '76,5';
drop user username cascade;

CREATE USER username IDENTIFIED BY Password12
    DEFAULT TABLESPACE TBS01
    TEMPORARY TABLESPACE TEMP
    QUOTA 8000M ON IDX01
    QUOTA 24000M ON TBS01
    PROFILE DEFAULT
    ACCOUNT UNLOCK

GRANT "CONNECT" TO username


exp parfile=export_data.txt
userid=system@dbtest_10.240.13.67
file=dbtestDATA.dmp
log=export_data.log
owner=dbtestADM
buffer=1000000

imp parfile=import_app.txt
userid=system@dbtest_10.240.13.67
file=dbtestAPPADM.dmp
fromuser=dbtestAPPADM
touser=dbtestAPPADMTEST
log=import_app.log

exp parfile=export_treftab.txt
userid=dbtestadm@dbtest_10.240.13.67
file=dbtestTREFTAB.dmp
log=export_treftab.log
buffer=1000000
tables=(TREFTAB)

imp parfile=import_treftab.txt
userid=hetty@dbtest_10.240.13.67
file=dbtestTREFTAB.dmp
buffer=1000000
tables=(TREFTAB)
log=import_treftab.log