-
编辑 删除
Oracle常用经典SQL查询
Oracle常用经典SQL查询oracle常用经典SQL查询常用SQL查询：1、查看表空间的名称及大小select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_sizeFrom dba_tablespaces t, dba_data_files dWhere t.tablespace_name = d.tablespace_namegroup by t.tablespace_name;2、查看表空间物理文件的名称及大小select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_spaceFrom dba_data_filesorder by tablespace_name;3、查看回滚段名称及大小select segment_name, tablespace_name, r.status,(initial_extent/1
-
编辑 删除
今天试用了外部表装载数据
创建外部表的脚本：create table ext(ID VARCHAR2(10),PWD VARCHAR2(10))ORGANIZATION EXTERNAL(type oracle_loaderdefault directory extiraccess parameters(records delimited by newlineskip 0fields terminated by ","(id,pwd))location('test.ctl'))test.ctl内容:LOAD DATAINFILE *INTO TABLE TESTFIELDS TERMINATED BY ","(ID,PWD)BEGINDATAJASON,KKJJ,AASDF,DD产生如下错误：SQL> select * from ext;select * from ext*ERROR at line 1:ORA-29913: error in executing ODCIEXTTABLEFETCH calloutORA-30653
