ÈçÔÀ´¼ÆËã»úÃû½Ð "Apple",µÇ¼ʱʹÓà http://apple:1158/em
¶øÏÖÔڸijÉ"red"ÁË,ÎÒÈçºÎµÇ¼ÎÒµÄoracle em
ллÁË.
localhost:1158/em
µÇ¼ÊÔÊÔ£¬¼ÆËã»ú¸ÄÃû¿ÉÄÜ»áÒý·¢Ò»Ð©±ðµÄÎÊÌâ
½ø²»È¥.
Äã¼ì²éÏ£¬·þÎñûÆô¶¯°É
ÂÛ̳ÀïËÑË÷Ï£¬ÀàËƵÄÌû×Ӻܶà
¿´¿´Õâ¸ö¶ÔÄãÓÐûÓÐÓÃ
......
ÇëÎÊoracleÖн¨Á¢ÁÙʱ±í¿Õ¼äʱ£¬temp.dbfÕâ¸öÎļþÊÇÊÂÏÈ´æÔڵĻ¹ÊÇÔËÐÐÍêÏÂÃæµÄSQL¾Í»á×Ô¶¯´´½¨£¿Èç¹ûÊÇÊÂÏÈ´æÔڵģ¬ÄÇÊÇʲôÎļþ¸ñʽÄØ£¿ÈçºÎÕÒµ½£¿Ð»Ð»£¡
alter tablespace temp add tempfile ¡®/tstora/oradata/ora920/ttlorae3/temp.dbf¡¯ size 512m
ÔÚ´´½¨Êý¾Ý¿âµÄʱºò£¬ÓиöÑ¡Ï¾ÍÊÇ´´½¨ÄÄЩ¶ÔÏó£¬ÀïÃæ¾ÍÓÐ ......
ÎÒдµÄÒ»¸ö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· ......
ͬһ̨»úÆ÷ÉÏ£¬ÆäÖÐÒ»¸ö±¸·ÝÕý³£ <1>,ÁíÍâÒ»¸ö±¨´í <2>¡£Í¬Ò»Ì¨»úÆ÷Éϵ¼³öÈÕÖ¾ÏÔʾµÄ°æ±¾¾ÓÈ»²»Ò»Ñù£¬Äĸö¸ßÈ˸øÖ¸µãÏ¡£
ÎÒ»úÆ÷ÉÏ×°µÄÊÇOracle9i Enterprise Edition Release 9.2.0.8.0 - Production £¨client£©
<1>
Á¬½Óµ½: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production ......
MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£
ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ
תµÄʱºò°ÑtextתÎÊvarcharÐÍ.
ÒýÓÃ
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀ ......
ÎÒÄÜ·ñÖ¸¶¨oracleÖÐijÕűíuser1.table1 Ö»ÄÜÓÉÓû§user1²ÅÄܲéѯ£¿
»òÕߣ¬ÄÜ·ñÖ¸¶¨user1.table1¾ÍÊDz»Äܱ»Óû§user2²éѯ£¿
ȨÏÞ¿ØÖÆ£¬²»¸øÆäËû±ðµÄÓû§È¨Ï޾ͿÉÒÔÁË
grant,revoke½øÐÐȨÏÞÏÞÖÆ
grantÊÚȨ
[GRANT
Ãû³Æ
GRANT— ¸³ÓèÒ»¸öÓû§£¬Ò»¸ö×é»òËùÓÐÓû§·ÃÎÊȨÏÞ
GRANT privilege [, .. ......