oracle Êý¾ÝÀàÐÍ´ÓÄǸö±í»òÊÓͼ¶ÁÈ¡£¿¼±¼±¼±
oracle ÖÐÊý¾ÝÀàÐÍ¿ÉÒÔ´ÓÄǸöµØ·½»ñÈ¡µÃµ½
×Ô¼ºÃ¶¾ÙһϾÍÐÐÁ˰É
oracleÀàÐÍÈ磺NUMBER,CHAR,DATEµÈÕâЩÊý¾ÝÀàÐÍÎÒÏëµ½Êý¾Ý×ÖµäÈ¥²é³öÀ´
ÈçÎÒÒª²éÕâ¸ö¿âÀïËùÔڵıíÎÒ¿ÉÒÔÓãºSELECT * from DBA_TABLES;
ÊDz»ÊDzéORACLEÀàÐÍÒ²ÓÐͬÑùµÄÒ»¸ö±í»òÊÓͼ??
ÕÒÁËһϣ¬Ã»ÕÒµ½Ïà¹ØµÄÊý¾Ý×Öµä
select * from dba_types where owner is null
ллÄãµÄ»Ø¸´
Äܲ»ÄÜ°ÑÆä³¤¶ÈÒ²ÏÔʾµÄ
È磺VARCHAR2ÊÇ4000Õâ¸öÒ²²é³öÀ´ÏÔʾ
SELECT T.TABLE_NAME, -- ±íÃû
T.COLUMN_NAME,--ÁÐÃû
T.DATA_TYPE || '(' || T.DATA_LENGTH || ')' DATA_TYPE, --×Ö¶ÎÀàÐÍ
T.DATA_PRECISION,--ÕûÊýλ
T.DATA_SCALE, --СÊýλ
T.NULLABLE,-- ÔÊÐí¿ÕÖµ
C.comments -- ±¸×¢
from USER_TAB_COLS T, USER_COL_COMMENTS C
WHERE T.TABLE_NAME = C.table_name
AND T.COLUMN_NAME = C.column_name
AND T.TABLE_NAME = '&TABLE_NAME';
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ
¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬
A B
1 2
2 3
3 4
4
ÓÐÕâÑùһЩÊý¾Ý
ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý
COLA COL1 COL3 COL2 COL1
4 4 ......