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

oracle Êý¾Ý¹ÜÀí

 Ò»£º
ʹÓÃProfile¶ÔÓû§Session»á»°½øÐÐ×ÊÔ´ÏÞÖÆ
--µ«ÊÇÈç¹ûʹÓÃÁËÁ¬½Ó³ØÖ®ÀàµÄ¶«¶«£¬¾Í»á³öЩÎÊÌ⣬±ÈÈçǰ̨Á¬½Ó²»ÉÏÖ®ÀàµÄ
--http://www.eygle.com/archives/2008/10/profile_session_limit.html
sqlplus "/ as sysdba"
SQL> show parameter resource
SQL> alter system set resource_limit=true;
SQL> SELECT * from DBA_PROFILES;
--´´½¨Ò»¸öÔÊÐí3·ÖÖÓIDLEʱ¼äµÄPROFILE£º
SQL> CREATE PROFILE KILLIDLE LIMIT IDLE_TIME 3;
Profile created.
SQL> col limit for a10
SQL> select * from dba_profiles where profile='KILLIDLE';
SQL> alter user eygle profile killidle;
SQL> select username,profile from dba_users where username='EYGLE';
¶þ£º
ÈçºÎ°ÑÊý¾Ýµ¼È벻ͬµÄ±í¿Õ¼ä
--http://www.eygle.com/archives/2005/04/ecineeeeiaeioae.html
»ØÊÕÓû§unlimited tablespaceȨÏÞ
ÕâÑù¾Í¿ÉÒÔµ¼Èëµ½Óû§È±Ê¡±í¿Õ¼ä
SQL> create user bjbbs identified by passwd
  2  default tablespace bjbbs
  3  temporary tablespace temp
  4  /
User created.
SQL> grant connect,resource to bjbbs;
Grant succeeded.
SQL> grant dba to bjbbs;
Grant succeeded.
SQL> revoke unlimited tablespace from bjbbs;
Revoke succeeded.
SQL> alter user bjbbs quota 0 on users;
User altered.
SQL> alter user bjbbs quota unlimited on bjbbs;
User altered.
SQL> exit
ÖØе¼ÈëÊý¾Ý
$ imp bjbbs/passwd file=bj_bbs.dmp fromuser=jive touser=bjbbs grants=n
SQL> select table_name,tablespace_name from user_tables;
Ôò¿ÉÒԲ鿴µ½Êý¾Ýµ¼ÈëÁËbjbbs
Èý£º
OracleÖÐÄ£Äâ¼°ÐÞ¸´Êý¾Ý¿éËð»µ
--http://www.eygle.com/faq/Block_corruption.htm
Ò»¸öÊý¾Ý¿éË𻵺ó²éѯ»á³öÏÖÈçÏ´íÎóÌáʾ
SQL> select count(*) from eygle.t;
select count(*) from eygle.t
*
ERROR λÓÚµÚ 1 ÐÐ:
ORA-01578: ORACLE Êý¾Ý¿éË𻵣¨ÎļþºÅ4£¬¿éºÅ35£©
ORA-01110: Êý¾ÝÎļþ 4: 'E:\ORACLE\ORADATA\EYGLE\BLOCK.DBF'
SQL>
ÓиöÄÚ²¿¹¤¾ßBBEDÒ²¿ÉÒÔÓÃÀ´±à¼­Êý¾Ý¿éµÄÄÚÈÝ
ʹÓÃDBV¼ì²éÊý¾ÝÎļþ
E:\Oracle\oradata\eygle>dbv file=block.dbf blocksize=8192
DBVERIFY: Release 9.2.0.4.0 - Production on ÐÇÆÚÒ» 3ÔÂ 8 20:48


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Oracle OCI programming and Borland C++ Builder

As you may know, Oracle dropped support for Borland Compilers in OCI
some time back. Well, it isn't all that hard to set up again.
I'm running 9i Release 2 Enterprise Edition on this PC at work and I am
using Borland C++ Builder 6 to 'play' with OCI programming - I intend to
build a set of compo ......

ORACLE OMF½éÉÜ

ÏÈ¿´Oracle ¹Ù·½½âÊÍ
Oracle managed file (OMF)
A file that is created automatically by the Oracle database server when it is needed and automatically deleted when it is no longer needed.
 
ÈçºÎÅжÏÄãµÄÊý¾Ý¿âÊÇ·ñΪ֧³ÖOMF
SQL> show parameter db_create_file_dest;
 
NAME  & ......

OracleÊý¾Ý¿â×Ô¶¨ÒåÒì³£µÄʹÓ÷½·¨

 À´Ô´£º²»Ïê  ×÷ÕߣºØýÃû  Ê±¼ä£º2009-9-6 17:14:04 Tags£º Orac ʹÓ÷½·¨
ÐèÇó£ºÒµÎñÂß¼­ÔÚ´¦ÀíÊý¾Ýʱ£¬ÐèÒª·µ»ØMessage²¢×èÖ¹³ÌÐòµÄ¼ÌÐøÔËÐС£µ«ÊÇ£¬ÔÚ´æ´¢¹ý³ÌʹÓÃOracleÊý¾Ý¿âµÄRaise¸ù±¾ÎÞ·¨Âú×ãÏÖÔÚµÄÒªÇó¡£
½â¾ö·½·¨£º
ʹÓÃRAISE_APPLICATION_ERROR
RAISE_APPLICATION_ERROR ( erro ......

ѧϰoracle sql loader µÄʹÓÃ

Ò»£ºsql loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
 ±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ