Oracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÐÅÏ¢£ºDBA_PART_TABLES
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íÐÅÏ¢£ºALL_PART_TABLES
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÐÅÏ¢£ºUSER_PART_TABLES
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºDBA_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºALL_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºUSER_TAB_PARTITIONS
ÏÔʾ×Ó·ÖÇøÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓÐ×éºÏ·ÖÇø±íµÄ×Ó·ÖÇøÐÅÏ¢£ºDBA_TAB_SUBPARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓÐ×éºÏ·ÖÇø±íµÄ×Ó·ÖÇøÐÅÏ¢£ºALL_TAB_SUBPARTITIONS
ÏÔʾµ±Ç°Óû§ËùÓÐ×éºÏ·ÖÇø±íµÄ×Ó·ÖÇøÐÅÏ¢£ºUSER_TAB_SUBPARTITIONS
ÏÔʾ·ÖÇøÁÐ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄ·ÖÇøÁÐÐÅÏ¢£ºDBA_PART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄ·ÖÇøÁÐÐÅÏ¢£ºALL_PART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄ·ÖÇøÁÐÐÅÏ¢£ºUSER_PART_KEY_COLUMNS
ÏÔʾ×Ó·ÖÇøÁÐ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄ×Ó·ÖÇøÁÐÐÅÏ¢£ºDBA_SUBPART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄ×Ó·ÖÇøÁÐÐÅÏ¢£ºALL_SUBPART_KEY_COLUMNS
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄ×Ó·ÖÇøÁÐÐÅÏ¢£ºUSER_SUBPART_KEY_COLUMNS
---------------------------------------------------------------------------------------------------
ÔõÑù²éѯ³öOracleÊý¾Ý¿âÖÐËùÓеĵķÖÇø±í
select * from user_tables a where a.partitioned='YES'ɾ³ýÒ»¸ö±íµÄÊý¾ÝÊÇtruncate table table_name;
ɾ³ý·ÖÇø±íÒ»¸ö·ÖÇøµÄÊý¾ÝÊÇalter table table_name truncate partition p5;
Èç¹ûÎÒÒª½«·ÖÇø±íÖи÷¸ö·ÖÇøµÄÊý¾Ý¶¼Çå¿Õ£¬¿ÉÒÔÓÃtruncate table table_name;Âð£¿
»¹ÊDZØÐë´ÓÍ·Ö´ÐÐ
alter table table_name truncate partition p1; alter table table_name truncate partition p2; alter table table_name truncate partition p3; alter table table_name truncate partition p4; alter table table_name truncate partition p5; alter table table_name truncate partition p6;
´ð:truncate table table_name
ÒýÓõØÖ·:http://database.51cto.com/art/201004/195232.htm
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
Ò»£º»Ø¹ö¶Î¸ÅÊö
¡¡¡¡»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐÅÏ¢¡£Ò»¸öÊÂÎñÖ»ÄÜʹÓÃÒ»¸ö»Ø¹ö¶ÎÀ´´æ·ÅËüµÄ»Ø¹öÐÅÏ¢£¬¶øÒ»¸ö»Ø¹ö¶Î¿ÉÒÔ´æ·Å¶à¸öÊÂÎñµÄ»Ø¹öÐÅÏ¢¡£
»Ø¹ö¶ÎµÄ×÷ÓÃ
¡¡¡¡ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄǰµÄÖµ£¨¼´Ç°Ó°Ïñ£ ......
1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date is: ......
ÒÔǰ¾³£Ê¹ÓÃoracleµÄ¿Í»§¶Ë¹¤¾ßtoadÀ´½øÐÐÊý¾Ý¿âµÄµ¼ÈëºÍµ¼³ö£¬Æäʵ¸öÈ˵¹²»Ï²»¶ÓÃÕâ¸ö¿Í»§¶Ë¹¤¾ß£¬¸Ð¾õ¹¦ÄܺÜÇ¿´óµÄÒ»¸ö¹¤¾ß£¬dbaÊÊÓ᣿ª·¢»¹ÊÇÓÃpl/sql±È½ÏºÃ£¬¼ò½àµÄ½çÃæ¡£
C:\Users\Administrator>imp nwgis/pass file=e:/nwgis20100529.DMP log=dible_db full=y ignore=y
Æô¶¯ÃüÁîÐУ¬ÐÞ¸Ä ......
oracleÖÐpro*cµÄѧϰ
¡¡Ò» Pro*C ³ÌÐò¸ÅÊö£º
1£®Ê²Ã´ÊÇPro*C³ÌÐò
ÔÚORACLEÊý¾Ý¿â¹ÜÀíºÍϵͳÖУ¬ ÓÐÈýÖÖ·ÃÎÊÊý¾Ý¿âµÄ·½·¨£»
£¨1£© ÓÃSQL*Plus£¬ ËüÓÐSQLÃüÁîÒÔ½»»¥µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£»
£¨2£© ÓõÚËÄ´úÓïÑÔÓ¦Óÿª·¢¹¤¾ß¿ª·¢µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£¬ÕâЩ¹¤¾ßÓÐSQL*froms£¬QL*Reportwriter,SQL*MenuµÈ£»
£¨3£© ÀûÓÃÔÚ ......