iteye_12188的博客

1:创建dblinkcreate database link dblink_name connect to userA IDENTIFIED BY userA using '192.168.0.1/ora92';2:查看表空间select dbf.tablespace_name,dbf.totalspace "总量(M)",dbf.totalblocks as ...

1:带where参数的导出数据exp m/a@192.168.0.1/orc11u file="rry_all.dmp" log="ll_exp.log" tables=rry query=\"where (to_char(upload_date, 'YYYY-MM-DD')

1.INSERT INTO SELECT语句 语句形式为：Insert into Table2(field1,field2,...) select value1,value2,... from Table1 要求目标表Table2必须存在，由于目标表Table2已经存在，所以我们除了插入源表Table1的字段外，还可以插入常量。2：SELECT INTO...

1：在64位系统中安装32位的oracle注册表的位置是:MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_OraDb10g_home12:ORA-00059: 超出 DB_FILES 的最大值必须在数据库服务器上执行>sqlplus sys/xxx@ora10 as sysdbaSQL> alter system set db_files...