I have installed the Personal Edition of Oracle 8i. Now I am trying to connect with VisualCafe, but I can't figure out what the default database name is that Oracle automatically assigned to the default database that it created upon installation.
VisualCafe wants a *subprotocol* entry in the format:
to set up the database navigator, which I can't figure out.
Is there an SQL statement that I can run, that will tell me the name of the database that I have connected to? (I connect with SQL Plus but there isn't any host string, since it is a local database). Can I do a search for a file name? Is the simplest solution to create a new database and forget about the default one? If so, what is the SQL to create the database (if I can create it properly, I can figure out how to add the tables, etc.).