Oracle±í¿Õ¼ä
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 tablespace zfmi
logging
datafile 'D:\oracle\oradata\zfmi\zfmi.dbf'
size 100m
autoextend on
next 32m maxsize 2048m
extent management local;
//datafile²ÎÊý±ØÐëÓÐ
//ɾ³ýÓû§ÒÔ¼°Óû§ËùÓеĶÔÏó
drop user zfmi cascade;
//cascade²ÎÊýÊǼ¶ÁªÉ¾³ý¸ÃÓû§ËùÓжÔÏ󣬾³£Óöµ½ÈçÓû§ÓжÔÏó¶øδ¼Ó´Ë²ÎÊýÔòÓû§É¾²»Á˵ÄÎÊÌ⣬ËùÒÔÏ°¹ßÐԵļӴ˲ÎÊý
//ɾ³ý±í¿Õ¼ä
Ç°Ì᣺ɾ³ý±í¿Õ¼ä֮ǰҪȷÈϸñí¿Õ¼äûÓб»ÆäËûÓû§Ê¹ÓÃÖ®ºóÔÙ×öɾ³ý
drop tablespace zfmi including contents and datafiles cascade onstraints;
//including contents ɾ³ý±í¿Õ¼äÖеÄÄÚÈÝ£¬Èç¹ûɾ³ý±í¿Õ¼ä֮ǰ±í¿Õ¼äÖÐÓÐÄÚÈÝ£¬¶øδ¼Ó´Ë²ÎÊý£¬±í¿Õ¼äɾ²»µô£¬ËùÒÔÏ°¹ßÐԵļӴ˲ÎÊý
//including datafiles ɾ³ý±í¿Õ¼äÖеÄÊý¾ÝÎļþ
//cascade constraints ͬʱɾ³ýtablespaceÖбíµÄÍâ¼ü²ÎÕÕ
Èç¹ûɾ³ý±í¿Õ¼ä֮ǰɾ³ýÁ˱í¿Õ¼äÎļþ£¬½â¾ö°ì·¨:
Èç¹ûÔÚÇå³ý±í¿Õ¼ä֮ǰ£¬ÏÈɾ³ýÁ˱í¿Õ¼ä¶ÔÓ¦µÄÊý¾ÝÎļþ£¬»áÔì³ÉÊý¾Ý¿âÎÞ·¨Õý³£Æô¶¯ºÍ¹Ø±Õ¡£
¿ÉʹÓÃÈçÏ·½·¨»Ö¸´£¨´Ë·½·¨ÒѾÔÚoracle9iÖÐÑé֤ͨ¹ý£©£º
ÏÂÃæµÄ¹ý³ÌÖУ¬filenameÊÇÒѾ±»É¾³ýµÄÊý¾ÝÎļþ£¬Èç¹ûÓжà¸ö£¬ÔòÐèÒª¶à´ÎÖ´ÐУ»tablespace_nameÊÇÏàÓ¦µÄ±í¿Õ¼äµÄÃû³Æ¡£
$ sqlplus /nolog
SQL> conn / as sysdba;
Èç¹ûÊý¾Ý¿âÒѾÆô¶¯£¬ÔòÐèÒªÏÈÖ´ÐÐÏÂÃæÕâÐУº
SQL> shutdown abort
SQL> startup mount
SQL> alter database datafile 'filename' offline drop;
SQL> alter database open;
SQL> drop tablespace tablespace_name including contents;
//´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
create user zfmi identified by zfmi
default tablespace zfmi temporary tablespace zfmi_temp;
//identified by ²ÎÊý±ØÐëÓÐ
//ÊÚÓèmessageÓû§DBA½ÇÉ«µÄËùÓÐȨÏÞ
GRANT DBA TO zfmi;
//¸øÓû§ÊÚÓèȨÏÞ
grant connect,resource to zfmi; (db2£ºÖ¸¶¨ËùÓÐȨÏÞ)
µ¼Èëµ¼³öÃüÁ
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdm
Ïà¹ØÎĵµ£º
There are lots of problems with Oracle DATE & TIMESTAMP and their
counterpart Java classes since they do not directly compare. DATE fields
in Oracle will give date & time where a ......
1. ×¼±¸¹¤×÷
°Ñ¾ÉµÄORACLEËùÓÐÎļþ¶¼COPY±¸·ÝÏÂÀ´,ɾ³ý¾ÉĿ¼,ÔÙÖØа²×°ORACLE,Ŀ¼ºÍ¾ÉĿ¼һÑù(Èç¹û²»Ò»Ñù,ÒªÐ޸ĵĵط½±È½Ï¶à).Ö»°²×°ORACLE,²»´´½¨Êý¾Ý¿â¡£Òª»Ö¸´µÄʵÀýΪORCL ¡£
2.ÓÃÃüÁʽ£¬Í¨¹ýÒª¾ÉµÄORAÎļþ´´½¨ÐµÄʵÀýORCL
a) oradim -new -sid ORCL£¨´´½¨ÊµÀý£ ......
¶ÔÓÚinstrº¯Êý£¬ÎÒÃǾ³£ÕâÑùʹÓ㺴ÓÒ»¸ö×Ö·û´®ÖвéÕÒÖ¸¶¨×Ó´®µÄλÖá£Àý
È磺
SQL> select
instr('yuechaotianyuechao','ao') position from dual;
POSITION
----------
6
´Ó×Ö·û´®'yuechaotianyuechao'µÄµÚÒ»¸öλÖÿªÊ¼£¬Ïòºó² ......
»ù±¾´ÓÀ´²»ÓÃleft/right join
Ò»¸öÏîÄ¿±»ÆÈÒªÓñðÈËдµÄ sql
±¾´òËã¸ÄдһÏ£¬Ìá¸ßЧÂÊ
·¢ÏÖ£º
¡¾1¡¿
select * from a
left outer join b on a.id= b.id AND ...1...
where ...2...
Óë
¡¾2¡¿
select * from a , b
where a.id= b.id(+)
A ......