Êý¾Ý¿âËùÔÚÓ²Å̿ռäʣϵIJ»¶àÁË£¬ËùÒÔÎÒɾ³ýÁËһЩ²»ÐèÒªµÄÓû§£º
drop user B0901 cascade;
drop user B0902 cascade;
drop user B0903 cascade;
µ«ÊÇɾ³ýÓû§ºó£¬¿Õ¼äÒ»µã±ä»¯¶¼Ã»ÓС£¡£¡£
Õ⼸¸öÓû§Ê¹ÓõÄTABLESPACE¶¼ÊÇUSERS
ÏÖÔÚÎÒ²éϵͳÖл¹ÓкܶàÓû§Ê¹ÓÃÕâ¸öUSERS±í¿Õ¼ä£º
SQL> select username,default_tablespace from dba_users;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
A0908 USERS
A0901 USERS
A0904 USERS
A0907 USERS
A0909 USERS
A0905 USERS
ÏÖÔÚÎÒµÄÎÊÌâÊÇ£¬ÈçºÎÒªÊÍ·ÅÒѾɾ³ýÓû§ËùÕ¼ÓõĴÅÅ̿ռ䣬¶ø²»Ó°ÏìÆäËûʹÓÃUSERS±í¿Õ¼äµÄÓû§£¿
ÄÇÄãÊDz»ÊǴ󲿷ֵÄobjects²¢²»ÊÇÔÚusrsÀïÃæ°¡¡£
USERNAME DEFAULT_TABLESPACE
Ïà¹ØÎÊ´ð£º
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ΪʲôÔÚwindows7ÉÏ×°²»ÉÏoracleÊý¾Ý¿â£¿£¿£¿
ÒòΪ²»Ö§³Ö
¿ÉÒÔ°²×°Êý¾Ý°¡£¬ ÄãÓõÄÄǸö°æ±¾µÄWindows 7°¡£¬Ä¿Ç°7600µÄ¼æÈÝÐÔÓкܴóÌáÉýÁË£¬£¬ÎÒÊÇÓÃSQL Sever 2005£¬¾ÍûÓÐÎÊÌ⣬oracleÓ¦¸ÃÒ²¿ÉÒԵģ¬Èç¹û²» ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖǰ¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐǰ¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆÎªÏµÍ³ºó¶Ë£©
ǰ¶ËÔ¼Êø ÊÇʲôÒâ˼£¿
ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£
......
ConnectÁ¬½ÓûÎÊÌ⣬²éѯÓï¾äÔÚworksheetÀïÄܲé³öÒ»Ìõ£¬µ«ÊÇreturn ocd.ExecuteReader()ȴûÓÐÕâÌõÊý¾Ý£¬Çë½ÌÏÂ
C# code:
string m_ConnectionString = "User ID=DQADMIN;Data Source=MyBASE;Pa ......