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

oracle ÈçºÎµ¼³öÊý¾Ý×Öµä

-- ²éѯij±íµÄÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ1",A.DATA_TYPE AS "×Ö¶ÎÀàÐÍ",A.DATA_PRECISION AS "ÓÐЧλ",A.DATA_SCALE AS "¾«¶ÈÖµ",
A.CHAR_LENGTH AS "×ֶ㤶È",A.NULLABLE AS "ÄÜ·ñΪ¿Õ"
 from sys.user_tab_columns A where A.table_name = 'TAM_ADDRESS'
 
--  ¾ßÓÐdbaȨÏÞÓû§µ¼³öÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ",A.DATA_DEFAULT AS "ĬÈÏÖµ",
A.NULLABLE AS "ÄÜ·ñΪ¿Õ",B.comments AS "±¸×¢"
from sys.all_tab_columns A,sys.DBA_COL_COMMENTS B
WHERE A.owner=B.owner AND A.table_name=B.table_name  AND A.COLUMN_NAME=B.COLUMN_NAME AND A.owner='guoqiang'  AND
A.TABLE_NAME IN (
'TB_SUBJECT', 'TB_SUBJECT_BALANCE', 'TB_VOUCHER', 'TB_VOUCHER_DETAILS',
'TB_CUSTOMER', 'TB_VOUCHER_CLASSIFY_MODE', 'TB_VOUCHER_TYPE', 'TB_ASSET',
'TB_ASSET_CATALOG', 'TB_M_DM_ASSETS_LIABI_RPT', 'TB_M_DM_PROFIT_RPT',
'TB_M_DM_REVENUE_RPT', 'TB_M_DM_COST_RPT'
)
ORDER BY A.TABLE_NAME
--Ò»°ãÓû§µ¼³ö¸ÃÓû§ÏµÄÊý¾Ý×Öµä
 SELECT  A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
 DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
 A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ",A.DATA_DEFAULT AS "ĬÈÏÖµ",
A.NULLABLE AS "ÄÜ·ñΪ¿Õ",B.comments AS "±¸×¢"
from sys.user_tab_columns A,sys.user_col_comments B
WHERE A.table_name=B.table_name  AND A.COLUMN_NAME=B.COLUMN_NAME AND
A.TABLE_NAME IN (
'TB_SUBJECT', 'TB_SUBJECT_BALANCE', 'TB_VOUCHER', 'TB_VOUCHER_DETAILS',
'TB_CUSTOMER', 'TB_VOUCHER_CLASSIFY_MODE', 'TB_VOUCHER_TYPE', 'T


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle 11g ÐÂÌØÐÔ¼ò½é

 
Oracle 11gÓÚ2007Äê7ÔÂ11ÈÕÃÀ¹ú¶«²¿Ê±¼ä11ʱ£¨±±¾©Ê±¼ä11ÈÕ22ʱ£©Õýʽ·¢²¼£¬11gÊǼ׹ÇÎĹ«Ë¾30ÄêÀ´·¢²¼µÄ×îÖØÒªµÄÊý¾Ý¿â°æ±¾£¬¸ù¾ÝÓû§µÄÐèÇóʵÏÖÁËÐÅÏ¢ÉúÃüÖÜÆÚ¹ÜÀí£¨Information Lifecycle Management£©µÈ¶àÏС£ 
 
Ò»£®ÐÂÌØÐÔÌá¸Ù
 
1.Êý¾Ý¿â¹ÜÀí²¿·Ö
¡ôÊý¾Ý¿âÖØÑÝ(Database Replay)&nb ......

oracle¿çÊý¾Ý¿â·ÃÎÊ

      oracle£¨²âÊÔ»·¾³Îªoralce10g£©ÖУ¬ÈôΪͬһ¿âÖУ¬²éѯʱÓÚ±íÃûÇ°Ìí¼ÓÓû§Ãû¼´¿É¡£ ÈôΪ¿ç¿â´¦Àí£¬ÓÐÁ½ÖÖ·½·¨¡£
      µÚÒ»ÖÖ·½·¨£¬ÓÃDB_link´¦Àí¡£¶øÆä²»×ãÖ®´¦Îª²»ÄܲÙ×Ý´ó×ֶΡ£ÈçϲÙ×÷£º
          &nb ......

oracleÖÐTranslate()º¯ÊýÓ÷¨

  Ò»¡¢Óï·¨£º  
    TRANSLATE(string,from_str,to_str)  
  ¶þ¡¢Ä¿µÄ  
      ·µ»Ø½«£¨ËùÓгöÏֵģ©from_strÖеÄÿ¸ö×Ö·ûÌ滻Ϊto_strÖеÄÏàÓ¦×Ö·ûÒÔºóµÄstring¡£TRANSLATEÊÇREPLACEËùÌṩµÄ¹¦ÄܵÄÒ»¸ö³¬¼¯¡£Èç¹ûfrom_str±È  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ