Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

oracle ½âËøÓû§ÒÔ¼°ÖØÐÂÉèÖÃÓû§ÃÜÂë

ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
¡¡¡¡error£º the account is locked
¡¡¡¡È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔ­Òò¡£
¡¡¡¡1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
¡¡¡¡2.´ËÓû§±»¹ ......

oracleÖØ½¨ÃÜÂëÎļþ


[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 ......

Oracle´æ´¢¹ý³Ì×ܽá

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´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£ 
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
 
1 create or replace procedure NoParPro
2 as  ;
3 begin
4 ;
5 exception  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ