±¸·Ý/»Ö¸´OracleÊý¾Ý¿â
1¡¢±¸·ÝÖ¸¶¨µÄ±í¿Õ¼ä
Ê×ÏÈ£¬ÄãҪȷÈÏ×Ô¼ºµçÄÔÉÏÓÐexp.exeÕâ¸ö¶«¶«£¬²ÅÄܽøÐб¸·Ý¹¤×÷¡£
ÎÒÏëÒª±¸·ÝµÄÊÇÓû§ÃûΪcyyµÄ±í¿Õ¼ä£¬±¸·ÝÎļþ´òËã·ÅÔÚDÅÌ£¬²¢ÒÔbackup_oracle.dmpÃüÃû£¬Ë³±ã°ÑÈÕÖ¾ÎļþÒ²±¸·ÝһϺÃÁË¡£
ÔÚÃüÁîÐÐÇÃÈ룺
C:\Documents and Settings\Administrator>exp cyy/cyy@bsrs file=D:\backup_oracle.dmp log=D:\backup_oracle.log owner = (cyy)£»
ÕâÑù¾ÍOKÁË¡£
2¡¢½«±¸·ÝµÄÊý¾Ý»Ö¸´µ½Ö¸¶¨µÄ±í¿Õ¼ä
Ê×ÏÈ£¬ÄãҪȷÈÏ×Ô¼ºµÄµçÄÔÉÏÓÐimp.exeÕâ¸ö¶«¶«£¬²ÅÄܽøÐлָ´¹¤×÷¡£
ÎÒÏëÒª½«ÉÏÃ汸·ÝµÄÊý¾Ý»Ö¸´µ½Áíһ̨»úÆ÷ÉÏ£¬ÐµÄÊý¾Ý¿âʵÀý½Ðbsrs2,£¬Ðµıí¿Õ¼äÃû³Æ½ÐDBMS2£¬Õâ¸ö±í¿Õ¼ä¶ÔÓ¦µÄÓû§½Ðcyy2£¬ÃÜÂëÈÔΪcyy¡£
µÃÏȽøÈësqlplus£¬ÒÔdbaÉí·ÝµÇ¼£¬Ö´ÐÐÒÔϼ¸ÐУº
SQL> grant resource,connect to cyy2;
SQL> grant dba to cyy2; //¸³DBAȨÏÞ
SQL> revoke unlimited tablespace from cyy2; //³·Ïú´ËȨÏÞ
SQL> alter user cyy2 quota 0 on system; //½«Óû§cyy2ÔÚSystem±í¿Õ¼äµÄÅä¶îÖÃΪ0
SQL> alter user cyy2 quota unlimited on DBMS2; //ÉèÖÃÓû§cyy2ÔÚDBMS2±í¿Õ¼äÅä¶î²»ÊÜÏÞ¡£
¾¹ýÉÏÊöÉèÖú󣬾ͿÉÒÔÓÃimpµ¼ÈëÊý¾Ý£¬Êý¾Ý½«»á½øÈëÖ¸¶¨µÄDBMS2±í¿Õ¼ä£º
ÔÚÃüÁîÐÐÇÃÈ룺
C:\Documents and Settings\Administrator>imp cyy2/cyy@bsrs2 fromuser=cyy touser=cyy2 file=D:\backup_oracle.dmp ignore=y grants=n;
ÕâÑù¾ÍOKÁË¡£
Ïà¹ØÎĵµ£º
²ã´Î»¯²éѯ£º
select [level],colomn,...from table
[where where_clause]
[ [start with start_condition] [connect by prior prior_condition]&nbs ......
¶ÔÓÚinstrº¯Êý£¬ÎÒÃǾ³£ÕâÑùʹÓ㺴ÓÒ»¸ö×Ö·û´®ÖвéÕÒÖ¸¶¨×Ó´®µÄλÖá£Àý
È磺
SQL> select
instr('yuechaotianyuechao','ao') position from dual;
POSITION
----------
6
´Ó×Ö·û´®'yuechaotianyuechao'µÄµÚÒ»¸öλÖÿªÊ¼£¬Ïòºó² ......
Oracle´´½¨É¾³ýÓû§¡¢½ÇÉ«¡¢±í¿Õ¼ä¡¢µ¼Èëµ¼³ö¡¢...ÃüÁî×ܽá
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace zfmi_temp
tempfile 'D:\oracle\oradata\zfmi\zfmi_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//tempfile²ÎÊý±ØÐëÓÐ
//´´½¨Êý¾Ý±í¿Õ¼ä
create table ......
ʹÓÃSYSÓû§ÒÔSYSDBAÉí·ÝµÇ¼ϵͳ
²é¿´ÐÞ¸ÄÇ°sga_max_size£¬sga_target´óС
show parameter sga_max_size;
show parameter sga_target;
Ð޸IJÎÊý
alter system set sga_max_size=1600m scope=spfile;
alter system set sga_target=1600m scope=spfile;
²é¿´Ð޸ĺósga_max_size£¬sga_target´óС
show parameter sga_ ......
PRAGMA RESTRICT_REFERENCES()£¬Õâ¸öPRAGMA±È½Ï¸´ÔÓ£¬ ×ܵÄÀ´Ëµ£¬ËüÊÇÒ»¸ö³ÌÐò¸¨Öú¼ìÑéÂ룬¼ì²é×Ó³ÌÐòµÄ´¿¶È£¨PURITY£©£¬°ïÖú¼ìÑé×Ó³ÌÐòÊÇ·ñÓÐÎ¥·´¹æÔòµÄµØ·½¡£Ò»°ãÓÃÔÚº¯ÊýÉÏ£¬µ«µ±º¯Êýµ÷Óùý³Ìʱ£¬Ò²Òª×÷ÏàÓ¦µÄÉèÖüì²é¡£ÕâÊÇΪÁ˱ÜÃâµ±ÔÚDMLÓï¾äÉϵ÷Óú¯ÊýʱÕý³£Ö´Ðв»ÖÁÓÚ²úÉú´íÎó¡£
Óï·¨£¬PRAGMA ......