导入命令 进入cmd 输入: imp username/password@orcl file=D:\xxx.dmp full=y
SELECT TTT.NEXTVALFROM DUAL 序列取值
导出:exp cacheadm/cacheadm@orcl file=d:\db.dmp owner=cacheadm
导出单表:exp dshebin/5922446@orcl file=d:\db.dmp tables=(t1 , t2 , t3)
查询所以树 :
select * from ICOM_QUESTION_TREE_TABLE startwith tree_id=356 connectbyprior id=up_id andlevel=1
select * from ICOM_QUESTION_TREE_TABLE connectbyprior tree_id=ico_tree_id andlevel=2
andlevel 第几级