在蟾蜍中连接新的Oracle数据库时出现问题

问题描述:

亲爱的
我想创建新的数据库和架构,然后通过蟾蜍进行连接.
我已经遵循了这一步骤,
tns配置:

Dear
I want to create new database and schema then connecting through toad.
I have followed this step,
tns configuration:

SMS_FL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MIT-STA-03)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bdmit)
    )
  )



然后创建表空间:



then create table space:

CREATE BIGFILE TABLESPACE TBS_SMS_FL DATAFILE 'D:\oradata\TBS_SMS_FL.dbf' SIZE 256M
AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL;



然后创建用户:



then create User:

CREATE USER SMS_FL101 IDENTIFIED BY SMS_FLl101 DEFAULT TABLESPACE TBS_SMS_FL QUOTA UNLIMITED ON TBS_sms_fl;
GRANT DBA TO SMS_FL101;



但是问题就可以了,因为蟾蜍登录表单时我还没有数据库.我可能会错过一些东西.我很困惑.甲骨文请指导我.
Mahmud



but problem is this ok,because I haven''t got this database when toad login form May i miss something.I am confused.I am new in toad & oracle please guide me.
Mahmud

验证tnanames是否已在您的PC中正确更新.
在TOAD登录屏幕中,有一个名为tnanames editor ..的选项,单击该按钮..,添加新的数据库服务器..并保存..,

您可以在dorpdown ..强制完全键入数据库名称.它将自动配置.
此选项在新版本中可能会更改..,我具有适用于Oracle 8.0.0.38的TOAD

运气胸..,:rose :: rose :: rose :: rose:
Verify the tnanames are correctly updated in your pc..,

In TOAD login Screen there is option called tnanames editor.., click on that.., add your new database server.. and save..,
Or
You can Force fully type the databse name at dorpdown.., it will configure automatically..

This Option may changed in New versions.., I have TOAD for Oracle 8.0.0.38

Bust of Luck .., :rose::rose::rose::rose: