oracle ³£ÓòéѯÃüÁî
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
1¡¢Óû§£º
¡¡select username from dba_users;
¸Ä¿ÚÁî
¡¡alter user spgroup identified by spgtest;
2¡¢±í¿Õ¼ä£º
¡¡select * from dba_data_files;
¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡select tablespace_name,sum(bytes), sum(blocks)
from dba_free_space group by tablespace_name;//¿ÕÏбí¿Õ¼ä
¡¡select * from dba_data_files
where tablespace_name='RBS';//±í¿Õ¼ä¶ÔÓ¦µÄÊý¾ÝÎļþ
¡¡select * from dba_segments
where tablespace_name='INDEXS';
3¡¢Êý¾Ý¿â¶ÔÏó£º
¡¡select * from dba_objects;
¡¡CLUSTER¡¢DATABASE LINK¡¢FUNCTION¡¢INDEX¡¢LIBRARY¡¢PACKAGE¡¢PACKAGE BODY¡¢
¡¡PROCEDURE¡¢SEQUENCE¡¢SYNONYM¡¢TABLE¡¢TRIGGER¡¢TYPE¡¢UNDEFINED¡¢VIEW¡£
4¡¢±í£º
¡¡select * from dba_tables;
¡¡analyze my_table compute statistics;->dba_tablesºó6ÁÐ
¡¡select extent_id,bytes from dba_extents
¡¡where segment_name='CUSTOMERS' and segment_type='TABLE'
¡¡order by extent_id;//±íʹÓõÄextentµÄÐÅÏ¢¡£segment_type='ROLLBACK'²é¿´»Ø¹ö¶ÎµÄ¿Õ¼ä·ÖÅäÐÅÏ¢
¡¡ÁÐÐÅÏ¢£º
select distinct table_name
from user_tab_columns
where column_name='SO_TYPE_ID';
5¡¢Ë÷Òý£º¡¡
¡¡select * from dba_indexes;//Ë÷Òý£¬°üÀ¨Ö÷¼üË÷Òý
¡¡select * from dba_ind_columns;//Ë÷ÒýÁÐ
¡¡select i.index_name,i.uniqueness,c.column_name
from user_indexes i,user_ind_columns c
¡¡where i.index_name=c.index_name
¡¡and i.table_name ='ACC_NBR';//Áª½ÓʹÓÃ
6¡¢ÐòÁУº
¡¡select * from dba_sequences;
7¡¢ÊÓͼ£º
¡¡select * from dba_views;
¡¡select * from all_views;
text ¿ÉÓÃÓÚ²éѯÊÓͼÉú³ÉµÄ½Å±¾
8¡¢¾Û´Ø£º
¡¡select * from dba_clusters;
9¡¢¿ìÕÕ£º
¡¡select * from dba_snapshots;
¿ìÕÕ¡¢·ÖÇøÓ¦´æÔÚÏàÓ¦µÄ±í¿Õ¼ä¡£
10¡¢Í¬Òå´Ê£º
¡¡select * from dba_synonyms
where table_owner='SPGROUP';
//if owner is PUBLIC,then the synonyms is a public synonym.
¡¡if owner is one of users,then the synonyms is a private synonym.
11¡¢Êý¾Ý¿âÁ´£º
¡¡select * from dba_db_links;
ÔÚspbaseϽ¨Êý¾Ý¿âÁ´
¡¡create database link dbl_spnew
¡¡connect to spnew identified by s
Ïà¹ØÎĵµ£º
½çÃ濪·¢ÈËÔ±±¨ÓкܶàÖظ´Êý¾ÝÔÚÓû§È¨ÏÞ±í¡£È»ºóÎÒɾ³ýÁ˱íÊý¾Ýdelete ·½Ê½£¬ÐÞ¸ÄÁ˶ÔÓ¦µÄ´æ´¢¹ý³Ìʹ֮²»Öظ´£¡
ºóÀ´·¢ÏÖ ÖØÐÂÀ»ØµÄÊý¾ÝûȨÏÞ¡£ Ö»ºÃÉÁ»Øµ½½ñÌìÁ賿ÁË£¡
SQL> ALTER TABLE BA.T_POWER_ADMIN ENABLE ROW MOVEMENT;
Table altered
SQL> flashback table ba.t_Power_Admin to tim ......
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄÇ°ÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......
Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
1¡¢½«Ç¶Ì×±í¶¨ÒåΪPL/SQLµÄ³ÌÐò¹¹Ôì¿é
TYPE type_name IS TABLE OF element_type[NOT NULL];
ÈçÏÂÀýËùʾ£º
DECLARE
-- Define a nested table of variable length strings.
TYPE card_table IS TABLE OF VARCHAR2(5 CHAR);
-- Declare and initialize a n ......
ËÄ¡¢ÁªºÏÊý×éµÄʹÓ÷½·¨
ÁªºÏÊý×éÒÔÇ°±»³ÆΪPL/SQL±í¡£ÔÚ±íÖв»ÄÜʹÓÃÁªºÏÊý×飬ֻÄܽ«ËüÃÇÓÃ×÷³ÌÐòÉè¼ÆµÄ½á¹¹Ìå¡£Ö»ÄÜÔÚPL/SQLÖзÃÎÊÁªºÏÊý×é¡£
×¢Òâµ½ÁªºÏÊý×é´øÀ´µÄһЩ¹Ø¼üÎÊÌâÊǷdz£ÖØÒªµÄ¡£ÕâЩÎÊÌâʹÎÒÃǽéÉÜËüÃǵÄÓ÷¨Ê±£¬ÐèÒª²ÉȡһЩÌرðµÄ·½·¨¡£ÕâЩÎÊÌâ°üÀ¨£º
ÁªºÏÊý×é²»ÐèÒª³õʼ»¯£¬Ò²Ã»Óй¹Ô캯ÊýÓï·¨¡£ÔÚ ......
ORACLE 10GµÄ¼¯ºÏAPI
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......