-
编辑 删除
oracle初学者必备基础
oracle 基础 ............................................[@more@]51. 如何将小表放入keep池中? alter table xxx storage(buffer_pool keep); 52. 如何检查是否安装了某个patch? check that oraInventory 53. 如何使select语句使查询结果自动生成序号? select rownum,COL from table; 54. 如何知道数据裤中某个表所在的tablespace? select tablespace_name from user_tables where table_name='TEST';select * from user_tables中有个字段TABLESPACE_NAME，(oracle);select * from dba_segments where …; 55. 怎么在sqlplu
-
编辑 删除
copy 命令（转载）
使用SQL*Plus的COPY命令，可以在数据库间进行数据复制。1、将一个远程数据库的数据复制到本地数据库............................................[@more@]SQL> help copyCOPY----COPY copies data from a query to a table in a local or remotedatabase. COPY supports CHAR, DATE, LONG, NUMBER and VARCHAR2.COPY {FROM database | TO database | FROM database TO database}{APPEND|CREATE|INSERT|REPLACE} destination_table[(column, column, column, ...)] USING querywhere database has the following syntax:username[/pass
