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

ORACLEÓɽű¾µ½´´½¨Êý¾Ý¿âÍêÕû¹ý³Ì¡£

£¨1£©ÒÔSYSÉí·ÝµÇ½
conn sys/sysem_pwd as sysdba;
£¨2£©´´½¨amlyÓû§
create user amly identified by 9imly;
£¨3£©´´½¨±í¿Õ¼ä
create tablespace ts_amly datafile 'd:\amlyfile\test.dbf' size 100M;
£¨4£©½«±í¿Õ¼ä·ÖÅä¸øÓû§
alter user amly default tablespace ts_amly;
£¨5£©¸øÓû§ÊÚȨ
grant create session,create table,create view,unlimited tablespace to amly;
£¨6£©ÒÔamlyÉí·ÝµÇ½´´½¨±í£¨Ö´ÐÐSQL½Å±¾£©
create table tt_amly(in number(10));
@e:\test.sql;


Ïà¹ØÎĵµ£º

¹ØÓÚoracleÊý¾Ý¿â°²×°²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿âµÈÎÊÌâ


³õ³õѧϰoracle 10g,×î»ù±¾µÄÎÊÌâ¾ÍÊÇ°²×°Êý¾Ý¿â,³õ³õ°²×°Êý¾Ý¿âʱ,°²×°Óë±ðÈ˵Ķ¼²î²»¶à,¾ÍÊÇÔÚ×îºóʱ,²»ÄÜ×ÔÐÐÅä×°Êý¾Ý¿â,Òª×Ô¼ºÅäÖÃÊý¾Ý¿â,×îºó¾­¹ý×Ô¼ºµÄÅŲé:ÔÚ°²×°ÏµÍ³Ê±,ϵͳµÄ¼ÆËã»úÃû³Æ(×¢²á¼ÆËã»úʱÓõÄ)ΪӢÎÄ,Óû§Ãû³ÆΪÖÐÎÄ,Òò´Ë²»ÄÜ×ÔÐÐÅäÖÃÊý¾Ý¿â,
¾­¹ý±¾È˵Ķà´ÎʵÑé,ÔÚ¼ÆËã»úÃû³Æ¡¢Óû§ÃûΪӢÎĵÄ×´Ì¬Ï ......

Oracleϵͳ¹ÜÀíºÍϵͳ×ÊÁÏ»ñÈ¡µÄһЩ»ù±¾ÃüÁî

×ÊÁÏ»ñÈ¡×ÔѧϰºÎÃ÷Öø×÷<<Oracle DBA Åàѵ½Ì³Ì>>µÚ¶þ°æ֮ʱ.ÆäÖÐdba_¿ªÍ·µÄ±íÐèÒªÓÐsysdbaȨÏÞ²ÅÄÜ·ÃÎÊ.
1. »ñÈ¡Êý¾Ý¿âÃû×Ö,´´½¨ÈÕÆÚ,µ±Ç°Ä£Ê½,ÈÕ־ģʽµÈµÈ:
SELECT name,created,log_mode,open_mode from v$database;
2. »ñÈ¡ÔËÐÐʵÀýµÄÖ÷»úÃû,ʵÀýÃû,°æ±¾:
SELECT host_name,instance_name,ve ......

Install Oracle 10g for Solaris

 Ò»¡¢Ê×ÏÈÏÂÔØ
1¡£µ½OracleµÄOTNÕ¾µãÉÏÏÂÔØOracle10g for Solaris x86µÄ°²×°ÅÌ http://www.oracle.com/technology ... ocs/solx86soft.html 2¡£ÏÂÔØÍê±ÏÒԺ󣬵õ½solarisx86_DB_10_1_0_3_Disk1.cpio.gzÎļþ ½âѹ£¬Éú³ÉDisk1Ŀ¼ $ gunzip -c solarisx86_DB_10_1_0_3_Disk1.cpio.gz | cpio -idmv È»ºó¿´oracle 10g fo ......

oracle ×Ö·û¼¯ÎÊÌâ

1.oracle×Ö·û¼¯ÎÊÌ⣺
Êý¾Ý¿â×Ö·û¼¯ÎªZHS16BGK£¬ºº×ÖÔÚÊý¾Ý¿â´æ·ÅµÄʱºòÕ¼ÓÃÁ½¸ö×Ö½Ú
Êý¾Ý¿â×Ö·û¼¯ÎªUTF8£¬ºº×ÖÔÚÊý¾Ý¿âÀï´æ·ÅµÄʱºòÕ¼ÓÃÈý¸ö×Ö½Ú
ÓÉÓÚ×Ö·û¼¯²»Í¬£¬µ¼ÖÂÏÖÔÚÊý¾Ý¿âIMPµÄʱºòÓÐЩ±íµÄ×ֶγ¤¶È²»¹»£¬³öÏÖORA-12899: value too large for columnµÄ´íÎó¡£
ͨ¹ýÐÞ¸Ä×Ö·û¼¯¿ÉÒÔ½â¾öÕâÖÖÎÊÌâ¡£
2.utf-8ºÍunico ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ