oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.
ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£
°ï¶¥......
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977
SQL code:
select * from dba_objects;
Schema Objects
Clusters, Constraints, Database links, Database triggers, Dimensions, External procedure libraries,
Index-organized tables, Indexes, Indextypes, Java classes, Java resources, Java sources,
Materialized views, Materialized view logs, Mining models, Object tables, Object types, Object views,
Operators, Packages, Sequences, Stored functions, stored procedures, Synonyms, Tables, Views
Nonschema Objects
Contexts, Directories, Editions, Restore points, Roles, Rollback segments, Tablespaces, Users
SQL code:
--ÏÈ¿´¿´×Öµä±íÀïµÄÕâ¸ö
select distinct t.OBJECT_TYPE from dba_objects t;
±í¡¢ÊÓͼ¡¢´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¡¢½ÇÉ«¡¢Êý¾Ý¿â¡¢ÊµÀý¡¢Óû§¡¢¹æÔò¡
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......