Oracle 帮助

select user form dual;  --查用户权限

Netstat –a检查端口是否被占用

--创建表空间
CREATE tablespace tbs
datafile 'c:\tabs.dbf' size 10M;

--把tabs座位user用户的默认表空间
alter user default tablespace tabs;
connect test/test11

create table tre(t char(10),re nuber);

--受权限
conn / as sysdba

creat unlimited tablespace ,dba to test;

--创建表到其他表空间
create table ty(t char(10),y varchar2(10)) tablespace tt;

 

--察看控制文件
DESC v$controlfile

--察看状态
SELECT status,name from v$controlfile;

desc v$datafile
select file#,starus,name from v$datafile;
desc v$logfile
select member from v$logfile;

--参数文件
--spfiletfst..

 

imp80 cmtsnetstore file=wyz.dmp fromuser=cmtsnetstore touser=cmtsnetstore

change_on_install

internal/oracle as sysdba

CmtsNetStore

alter user test default tablespace tabs;

create tablespace tabs
datafile 'c:\tabs.dbf' size 10M;

grant unlimited tablespace ,dba to testuser;

 

create tablespace cmts
datafile 'd:\orant\DBF\CmtsNetServer.dbf' size 50M;

grant unlimited tablespace ,dba to testuser;

alter user test default tablespace cmts;

 

//备份还原

imp80 cmtsnetstore file=d:\wyz.dmp fromuser=cmtsnetstore touser=cmtsnetstore

exp80 cmtsnetstore/cmts526@cmts200 file=d:\cmts200.dmp full=y

imp cmtsnetstore/cmts526 file=  ignore=y full=y