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 ......
ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
¡¡¡¡error£º the account is locked
¡¡¡¡È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
¡¡¡¡1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
¡¡¡¡2.´ËÓû§±»¹ ......
[oracle@dba01 dbs]$ orapwd file=/oracle/app/oracle/product/10.2.0/db_1/dbs/orapworcl password=oracle entries=20 force=y
[oracle@dba01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 29 13:07:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Con ......
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´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4 ;
5 exception &nb ......