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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
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 ¹Ù·½½âÊÍ
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 & ......
À´Ô´£º²»Ïê ×÷ÕߣºØýÃû ʱ¼ä£º2009-9-6 17:14:04 Tags£º Orac ʹÓ÷½·¨
ÐèÇó£ºÒµÎñÂß¼ÔÚ´¦ÀíÊý¾Ýʱ£¬ÐèÒª·µ»ØMessage²¢×èÖ¹³ÌÐòµÄ¼ÌÐøÔËÐС£µ«ÊÇ£¬ÔÚ´æ´¢¹ý³ÌʹÓÃOracleÊý¾Ý¿âµÄRaise¸ù±¾ÎÞ·¨Âú×ãÏÖÔÚµÄÒªÇó¡£
½â¾ö·½·¨£º
ʹÓÃRAISE_APPLICATION_ERROR
RAISE_APPLICATION_ERROR ( erro ......
Ò»£ºsql loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......