导入:imp username/password@DBNAME file=d:\XX.dmp full=y
导出:exp username/password@DBNAME file=d:\XX.dmp
DBNAME:PLSQL的数据库显示名
full=y:所有
------------------------------------------------------------------
安装了ORACLE ,并且配置了连接文件,服务起开启(如:PLSQL可以登陆上)
然后登陆
http://172.16.30.100:1158/em
把用户删了。重新建一个用户。
--------------------------------------------------------
导出某个表
....
C:\Documents and Settings\Administrator>exp username/password@DBNAME
.......
输入数组提取缓冲区大小: 4096 >
导出文件: EXPDAT.DMP > d:/fileName.dmp
(1)E(完整的数据库), (2)U(用户) 或 (3)T(表): (2)U > T
导出表数据 (yes/no): yes >
压缩区 (yes/no): yes >
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出指定的表通过常规路径...
要导出的表 (T) 或分区 (T: P): (按 RETURN 退出) > tablename
. . 正在导出表 tablename导出了 2 行
要导出的表 (T) 或分区 (T: P): (按 RETURN 退出) >
成功终止导出, 没有出现警告。
C:\Documents and Settings\Administrator>
---------------------------------------------------------
查询所有的字段属性:
select
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
column_id,
nullable from ALL_TAB_COLUMNS where table_name='TABLE_NAME'
查询主键:
SELECT
COLUMN_NAME
FROM SYS.ALL_CONSTRAINTS A , SYS.ALL_CONS_COLUMNS B
WHERE A.TABLE_NAME='TABLE_NAME'
AND A.CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND A.CONSTRAINT_TYPE ='P'
分页:
select RN from
(
select A.*,rownum RN
from (select * from TABLE_NAME ) A
where rownum<=12
)
where RN>6
---------------------------------------
select * from sys.dba_tablespaces;
数据字典 DBA_TABLESPACES 中的字段和含义:
TABLESPACE_NAME
Tablespace name
BLOCK_SIZE
Tablespace block size
INITIAL_EXTENT
Default initial extent size
NEXT_EXTENT
Default incremental extent size
MIN_EXTENTS
Default minimum number of extents
MAX_EXTENTS
Default maximum number of extents
PCT_INCREASE
Default percent increase for extent size
MIN_EXTLEN
Minimum extent size for the tablespace
STATUS
"Tablespace status: "ONLINE","OFFLINE" or "READ
CONTENTS
Tablespace contents: "PERMANENT" or "TEMPORARY" or "UNDO"
LOGGING
Default logging attribute
FORCE_LOGGING
Tablespace force logging mode
EXTENT_MANAGEMENT
Extent management tracking: "DICTIONARY" or "LOCAL"
ALLOCATION_TYPE
Type of extent allocation in effect for this tablespace
PLUGGED_IN
--
SEGMENT_SPACE_MANAGEMENT
Segment space management tracking: "AUTO" or "MANUAL"