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

exp µ¼³ö EXP-00056: Óöµ½ ORACLE ´íÎó 904

ͬһ̨»úÆ÷ÉÏ£¬ÆäÖÐÒ»¸ö±¸·ÝÕý³£ <1>,ÁíÍâÒ»¸ö±¨´í <2>¡£Í¬Ò»Ì¨»úÆ÷Éϵ¼³öÈÕÖ¾ÏÔʾµÄ°æ±¾¾ÓÈ»²»Ò»Ñù£¬Äĸö¸ßÈ˸øÖ¸µãÏ¡£
ÎÒ»úÆ÷ÉÏ×°µÄÊÇOracle9i Enterprise Edition Release 9.2.0.8.0 - Production £¨client£©

<1>
Á¬½Óµ½: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Òѵ¼³ö ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯
¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­
ÔÚûÓо¯¸æµÄÇé¿öϳɹ¦ÖÕÖ¹µ¼³ö¡£

<2>Á¬½Óµ½: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Òѵ¼³ö ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯

¼´½«µ¼³öÖ¸¶¨µÄÓû§...
. ÕýÔÚµ¼³ö pre-schema ¹ý³Ì¶ÔÏóºÍ²Ù×÷
. ÕýÔÚµ¼³öÓû§ WLJGBAIS µÄÍⲿº¯Êý¿âÃû³Æ
. µ¼³ö PUBLIC ÀàÐÍͬÒå´Ê
. µ¼³ö˽ÓÐÀàÐÍͬÒå´Ê
. ÕýÔÚµ¼³öÓû§ WLJGBAIS µÄ¶ÔÏóÀàÐͶ¨Òå
¼´½«µ¼³ö WLJGBAIS µÄ¶ÔÏó ...
. ÕýÔÚµ¼³öÊý¾Ý¿âÁ´½Ó
. ÕýÔÚµ¼³öÐòºÅ
. ÕýÔÚµ¼³öȺ¼¯¶¨Òå
. ¼´½«µ¼³ö WLJGBAIS µÄ±íͨ¹ý³£¹æÂ·¾¶ ...
. . ÕýÔÚµ¼³ö±í                        T_ADVISE        55 Ðб»µ¼³ö
EXP-00056: Óöµ½ ORACLE ´íÎó 904
ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": Î


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

oracleÖÐresultset´íÎó

ÔÚoracleÖÐÓÃjdbcÀ´Á¬½ÓÊý¾Ý¿â£¬ÎªÊ²Ã´ResultsetÀïÃæÇ¶Ì×ResultSet,µ½Ñ­»·µÄµÚ¶þ´Î¾Í±¨¿ÕÖ¸Õ룬ÄÄλ֪µÀÊÇÔõô»ØÊÂÂð£¿
´úÂ룺Java code:
while(prors.next()){
System.out.println(prors.getRow ......

oracleÖÐÓɳöÉúÄêÔ»ñµÃÄêÁä

select sname,(2009-10-05)-birth
from student;

birth×Ö¶ÎÖдæµÄÊdzöÉúÄêÔ£¬Ïë²éѯ³öÀ´µÄ½á¹ûÊÇÄêÁ䣬¸ÃÈçºÎ²éѯ£¿
¼ÓÉÏdatediffº¯ÊýÊÔÊÔ

select sname, to_char(sysdate,'YYYY')- to_char( ......

Á¬½Ó±¾µØOracle,ÔÚ³ÌÐò²éѯ²»³öÊý¾Ý

ConnectÁ¬½ÓûÎÊÌ⣬²éѯÓï¾äÔÚworksheetÀïÄܲé³öÒ»Ìõ£¬µ«ÊÇreturn ocd.ExecuteReader()ȴûÓÐÕâÌõÊý¾Ý£¬Çë½ÌÏÂ


C# code:

string m_ConnectionString = "User ID=DQADMIN;Data Source=MyBASE;Pa ......

ɾ³ýORACLEÓû§ºó£¬¿Õ¼ä²»ÊͷŵÄÎÊÌâ

Êý¾Ý¿âËùÔÚÓ²Å̿ռäʣϵIJ»¶àÁË£¬ËùÒÔÎÒɾ³ýÁËһЩ²»ÐèÒªµÄÓû§£º
drop user B0901 cascade;
drop user B0902 cascade;
drop user B0903 cascade;

µ«ÊÇɾ³ýÓû§ºó£¬¿Õ¼äÒ»µã±ä»¯¶¼Ã»ÓС£¡£¡£
Õâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ