Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

¼ÆËã»úÃû¸ÄÁË,µ¼ÖÂoracle 10g em µÇ¼ÎÊÌâ?

ÈçÔ­À´¼ÆËã»úÃû½Ð "Apple",µÇ¼ʱʹÓà http://apple:1158/em
¶øÏÖÔڸijÉ"red"ÁË,ÎÒÈçºÎµÇ¼ÎÒµÄoracle em
ллÁË.
localhost:1158/em

µÇ¼ÊÔÊÔ£¬¼ÆËã»ú¸ÄÃû¿ÉÄÜ»áÒý·¢Ò»Ð©±ðµÄÎÊÌâ

½ø²»È¥.

Äã¼ì²éÏ£¬·þÎñûÆô¶¯°É
ÂÛ̳ÀïËÑË÷Ï£¬ÀàËƵÄÌû×Ӻܶà

¿´¿´Õâ¸ö¶ÔÄãÓÐûÓÐÓÃ
......

oracleÁÙʱ±í¿Õ¼äÎļþÎÊÌâ

ÇëÎÊoracleÖн¨Á¢ÁÙʱ±í¿Õ¼äʱ£¬temp.dbfÕâ¸öÎļþÊÇÊÂÏÈ´æÔڵĻ¹ÊÇÔËÐÐÍêÏÂÃæµÄSQL¾Í»á×Ô¶¯´´½¨£¿Èç¹ûÊÇÊÂÏÈ´æÔڵģ¬ÄÇÊÇʲôÎļþ¸ñʽÄØ£¿ÈçºÎÕÒµ½£¿Ð»Ð»£¡
alter tablespace temp add tempfile ¡®/tstora/oradata/ora920/ttlorae3/temp.dbf¡¯ size 512m

ÔÚ´´½¨Êý¾Ý¿âµÄʱºò£¬ÓиöÑ¡Ï¾ÍÊÇ´´½¨ÄÄЩ¶ÔÏó£¬ÀïÃæ¾ÍÓÐ ......

ÔÚÏßÇó½ÌÒ»¸öoracle jobÎÊÌ⣡¼±£¡

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103,
    'TRUNC(SYSDATE)+1.103');
  commit;
end;
Îҵı¾ÒâÊÇÿÌìµÄÁ賿2µã28· ......

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 ......

MSSQL to Oracle, text×Ö¶ÎÔõô´¦Àí

MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö

sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£

ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ

תµÄʱºò°ÑtextתÎÊvarcharÐÍ.


ÒýÓÃ
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀ ......

ÔõÑùÏÞÖÆoracleÖбíµÄ²éѯ

ÎÒÄÜ·ñÖ¸¶¨oracleÖÐijÕűíuser1.table1 Ö»ÄÜÓÉÓû§user1²ÅÄܲéѯ£¿
»òÕߣ¬ÄÜ·ñÖ¸¶¨user1.table1¾ÍÊDz»Äܱ»Óû§user2²éѯ£¿
ȨÏÞ¿ØÖÆ£¬²»¸øÆäËû±ðµÄÓû§È¨Ï޾ͿÉÒÔÁË

grant,revoke½øÐÐȨÏÞÏÞÖÆ

grantÊÚȨ

[GRANT
Ãû³Æ
GRANT— ¸³ÓèÒ»¸öÓû§£¬Ò»¸ö×é»òËùÓÐÓû§·ÃÎÊȨÏÞ

GRANT privilege [, .. ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [287] [288] [289] [290] 291 [292] [293] [294] [295] [296]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ