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

OracleÖ®¹ÜÀí½ÇÉ«


 
Ô¤¶¨Òå½ÇÉ«ÊÇoracleÌṩµÄ½ÇÉ«,ÕâЩ½ÇÉ«ÊÇÔÚ½¨Á¢Êý¾Ý¿â,°²×°Êý¾Ý×ÖµäÊÓͼºÎPL/SQL°üʱ½¨Á¢µÄ,²¢ÇÒÿÖÖ½ÇÉ«¶¼ÓÃÓÚÖ´ÐÐÒ»Ð©ÌØ¶¨¹ÜÀíÈÎÎñ.
1,CONNECT½ÇÉ«
CONNECT½ÇɫʱÔÚ½¨Á¢Êý¾Ý¿âʱ,oracleÖ´Ðнű¾SQL.BSQ×Ô¶¯½¨Á¢µÄ½ÇÉ«,¸Ã½ÇÉ«¾ßÓÐÓ¦Óÿª·¢ÈËÔ±ËùÐèµÄ¶àÊýȨÏÞ.CONNECT½ÇÉ«¾ßÓеÄËùÓÐϵͳȨÏÞÈçÏÂ:
ALTER SESSION Ð޸ĻỰ²ÎÊýÉèÖÃ
CREATE CLUSTER ½¨Á¢´Ø
CREATE DATABASE LINK ½¨Á¢Êý¾Ý¿âÁ´
CREATE SEQUENCE ½¨Á¢ÐòÁÐ
CREATE SESSION ½¨Á¢»á»°(Á¬½Óµ½Êý¾Ý¿â)
CREATE PUBLIC SYNONYM ½¨Á¢Í¬Òå´Ê
CREATE TABLE ½¨±í
CREATE VIEW ½¨Á¢ÊÓͼ
2,RECOURCE½ÇÉ«
RECOURCE ½ÇɫʱÔÚ½¨Á¢Êý¾Ý¿âʱ,oracleÖ´Ðнű¾SQL.BSQ×Ô¶¯½¨Á¢µÄ½ÇÉ«,¸Ã½ÇÉ«¾ßÓÐÓ¦Óÿª·¢ÈËÔ±ËùÐèµÄÆäËûȨÏÞ.È罨Á¢´æ´¢¹ý´Ó,´¥·¢Æ÷µÈ.½¨Á¢Êý¾Ý¿âÓû§ºó,Ò»°ãÇé¿öÏÂÖ»Òª¸øÓû§ÊÚÓèCONNECTºÍRECOURCE½ÇÉ«¾Í×ã¹»ÁË.ÐèҪעÒâµÄʱ,RECOURCE½ÇÉ«Òþº¬¾ßÓÐUNLIMITED TABLESPACEϵͳȨÏÞ.
CREATE CLUSTER ½¨Á¢´Ø
CREATE INDEXTYPE ½¨Á¢Ë÷ÒýÀàÐÍ
CREATE PROCEDURE ½¨Á¢PL/SQL³ÌÐòµ¥Ôª.
CREATE SEQUENCE ½¨Á¢ÐòÁÐ
CREATE TABLE ½¨±í
CREATE TRIGGER ½¨Á¢´¥·¢Æ÷
CREATE TYPE ½¨Á¢ÀàÐÍ
3.DBA
¸Ã½ÇÉ«¾ßÓÐËùÓÐϵͳȨÏÞºÍWITH ADMIN OPTIONÑ¡Ïî.ĬÈϵÄDBAÓû§ÎªSYSTEM,¸ÃÓû§¿ÉÒÔ½«ÏµÍ³È¨ÏÞÊÚÓèÆäËûÓû§,ÐèҪעÒâµÄÊÇ,DBA½ÇÉ«²»¾ß±¸SYSDBAºÍSYSOPERÌØÈ¨,¶øSYSDBAºÍSYSOPER×Ô¶¯¾ßÓÐDBA½ÇÉ«µÄËùÓÐȨÏÞ.
4,EXECUTE_CATALOG_ROLE
EXECUTE_CATELOG_ROLE½ÇÉ«ÌṩÁ˶ÔËùÓÐϵͳPL/SQL°ü(DBA_XXX)µÄEXECUTE¶ÔÏóȨÏÞ
5,SELECT_CATALOG_ROLE
¸Ã½ÇÉ«ÌṩÁËÔÚËùÓÐÊý¾Ý×Öµä(DBA_XXX)ÉϵÄSELECT¶ÔÏóȨÏÞ.
6,DELETE_CATALOG_ROLE
¸Ã½ÇÉ«ÌṩÁËϵͳÉ󼯱íSYS.AUD$ÉϵÄDELETE¶ÔÏóȨÏÞ.
7,EXP_FULL_DATABASE
¸Ã½ÇÉ«ÓÃÓÚÖ´ÐÐÊý¾Ý¿âµÄµ¼³ö²Ù×÷.¸Ã½ÇÉ«¾ßÓеÄȨÏ޺ͽÇɫΪ:
SELECT ANY TABLE ²éѯÈÎÒâ±í
BACKUP ANY TABLE ±¸·ÝÈÎÒâ±í
EXECUTE ANY PROCEDURE Ö´ÐÐÈκιý³Ì,º¯ÊýºÍ°ü
EXECUTE ANY TYPE Ö´ÐÐÈκζÔÏóÀàÐÍ
ADMINISTER RESOURCE MANAGER ¹ÜÀí×ÊÔ´¹ÜÀíÆ÷
EXECUTE_CATALOG_ROLE Ö´ÐÐÈκÎPL/SQLϵͳ°ü
SELECT_CATALOG_ROLE ²éѯÈκÎÊý¾Ý×Öµä
8.IMP_FULL_DATABASE
¸Ã½ÇÉ«ÓÃÓÚÖ´ÐÐÊý¾Ý¿âµ¼Èë²Ù×÷,Ëü°üº¬ÁËEXECUTE_CATALOG_ROLE,SELECT_CATALOG_ROLE½ÇÉ«ºÍ´óÁ¿ÏµÍ³È¨ÏÞ.
9.RECOVERY_CATALOG_OWNER
¸Ã½ÇɫΪ»Ö¸´Ä¿Â¼ËùÓÐÕßÌṩÁËϵͳȨÏÞ.
CREATE SESSION ½¨Á¢»á»°
ALTER SESSION


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Windows Ï OracleÊý¾Ý¿â×Ô¶¯±¸·ÝÅú´¦Àí½Å±¾

@echo off
REM ###########################################################
REM # Windows Server 2003ÏÂOracleÊý¾Ý¿â×Ô¶¯±¸·ÝÅú´¦Àí½Å±¾
REM ###########################################################
REM È¡µ±Ç°ÏµÍ³Ê±¼ä,¿ÉÄÜÒò²Ù×÷ϵͳ²»Í¬¶øÈ¡Öµ²»Ò»Ñù
set CURDATE=%date:~0,4%%date:~5,2%%date:~8,2%
se ......

Oracle¼ì²é¶ÔÏó[µÚ°ËÕ±ʼÇ]

 
Oracle ¼ì²é¶ÔÏó
8.3. Oracle¶ÔÏóµÄ״̬
¹²·ÖÁù¸ö²¿·Ö£¬·Ö±ðΪ£º¼ì²éOracle¿ØÖÆÎļþ״̬£»¼ì²éOracleÔÚÏßÈÕ־״̬£»¼ì²éOracle±í¿Õ¼äµÄ״̬£»¼ì²éOracleËùÓÐÊý¾ÝÎļþ״̬£»¼ì²éOracleËùÓÐ±í¡¢Ë÷Òý¡¢´æ´¢¹ý³Ì¡¢´¥·¢Æ÷¡¢°üµÈ¶ÔÏóµÄ״̬£»¼ì²éOracleËùÓлعö¶ÎµÄ״̬¡£
8.3.1. Oracle¿ØÖÆÎļþ״̬
¼ì²é¿ØÖÆÎļþ×´Ì ......

OracleÖ®EXPÓëIMP


 
ʹÓÃEXP
EXPÃüÁîÐÐÑ¡Ïî
1,BUFFER
¸ÃÑ¡ÏîÓÃÓÚÖ¸¶¨ÌáÈ¡ÐÐÊý¾ÝʱµÄ»º³åÇø³ß´ç.ͨ¹ýÉèÖøÃÑ¡Ïî,¿ÉÒÔÈ·¶¨µ¼³öʱÊý¾ÝÌáÆð³ß´ç.¸ÃÑ¡ÏîÖ»ÊÊÓÃÓÚ³£¹æÑ¡Ïî.
Exp scott/tiger tables=dept,emp file=a.dmp buffer=81920
2,COMPRESS
¸ÃÑ¡ÏîÓÃÓÚÖ¸¶¨µ¼Èë¹ÜÀí³õÊ¼Çø(INITIAL)µÄ·½·¨.ĬÈÏֵΪY.µ±ÉèÖøÃÑ¡ÏîΪYʱ,oracle»á½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ