Click here to Skip to main content
15,887,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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:
CSS
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:
SQL
CREATE USER SMS_FL101 IDENTIFIED BY SMS_FLl101 DEFAULT TABLESPACE TBS_SMS_FL QUOTA UNLIMITED ON TBS_sms_fl;
GRANT DBA TO SMS_FL101;


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
Posted

1 solution

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:
 
Share this answer
 
Comments
Mahmudunnabi 10-Nov-10 6:07am    
here is any problem,I have checked it
but still not show

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900