Oracle·¢²¼SunµÄ¸÷Ïî²úÆ·µÄδÀ´µÄFAQÁбí
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù±¾ÉÏÐû²¼ËÀÍöÁË.
Èç¹ûÎÞ·¨´ò¿ªÉÏÃæµÄµØÖ·,Ò²¿ÉÒÔ´ÓÕâÀï²é¿´Ïà¹ØµÄFAQ,µØÖ·ÊÇhttp://www.oracle.com/technology/community/sun-oracle-community-continuity.html
ÁíÍâ,Sun VirtualBox Õýʽ¸üÃûΪ Oracle VM VirtualBoxÁË,Ò»¸ö²úÆ·¾ÍÊÇÕâÑù,´ÓÃû×ÖÉϾÍÄÜÈÃÄãÍü¼ÇËüµÄ³öÉí.ͬʱ,2010ÄêµÄJavaOne´ó»áÒ²»á¼ÌÐø,Ö»ÊDz»ÖªµÀµ½Ê±»á²»»á±ä³ÉСºú×ÓCEOµÄÑݽ²Îę̀.
Ææ¹ÖµÄÊÇOracle˵Ҫͬʱ֧³Ö3¸öIDE,ÄãÏàÐÅÂð?
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò»¡¢²é¿´Êý¾Ý¿âÔËÐÐģʽ
¡¡¡¡¿ÉÒÔÓ󬼶Óû§£¨INTERNAL£©ÔÚSQLPLUSÖÐʹÓÃÃüÁîARCHIVE LOG LIST²é¿´
¡¡¡¡SQL> archive log list
¡¡¡¡Database log mode No Archive Mode
¡¡¡¡Automatic archivalDisabled
¡¡¡ ......
oracleͨ¹ý͸Ã÷Íø¹Ø£¨Oracle Transparent Geteways£©£¬·ÃÎÊms sql serverºÍÆäËûÊý¾Ý¿â
»·¾³£º
1¡¢ÔÚ°²×°ÓÐoracle·þÎñÆ÷¶Ë£¬ms sql serverµÄ¿Í»§¶Ë£¬Í¨¹ýoracleµÄ͸Ã÷Íø¹Ø·ÃÎÊms sql serverÊý¾Ý¿â
2¡¢ÔÚms sql ser ......
http://blog.csdn.net/XIAOHUI_LIAO/archive/2007/08/27/1759990.aspx
create materialized view [view_name]
refresh [fast|complete|force]
[
on [commit|demand] |
start with (start_time) next (next_time)
]
as
{´´½¨ÎﻯÊÓͼÓõIJéѯÓï¾ä}
ÒÔÉÏÊÇ ......
½ñÌìɾ³ýµÄ±í¿Õ¼ä°üº¬ÎﻯÊÓͼ±¨´í£¬ORA-23515: ʵÌ廯ÊÓͼºÍ/»òËüÃǵÄË÷Òý´æÔÚÓÚ±í¿Õ¼äÖÐ
¿´À´ÊÇÐèҪɾ³ýÎﻯÊÓͼ£¬Ö´ÐÐɾ³ý²Ù×÷£¬ÒòΪÊý¾ÝÌ«´óÁË£¬°ëÌìҲûŪÍ꣬ȡÏûÁË£¬ÉÏÍø²éÁíÍâÒ»ÖÖ·½·¨£¬É¾³ýÓû§£¬Ö¸¶¨cascade ²ÎÊý£¬ÕâÑù¾Í¿ÉÒÔÁË
ÎÒÊÔÁËһϸоõÓÃ
drop user user_name cascade;
ɾ³ýµÄ»¹ÊÇͦ¿ìµÄ£¬±Èɾ³ýÎï ......