I recently successfully installed Oracle
(OraDb11g_home1) on Windows 7, and I was able to install Oracle Sql Developer (3.2....). I can log on to Oracle via Sql Developer, but all I have is connection "Orcl", user name = "sys as sysdba", via TNS, and this is all system tables
- Where do I find tnsnames on Windows 7 ? I can't seem to find it.
- How do I create a create a new instance / schema, separate from the system tables ?
- Can I get a sample d.b. somewhere, like Sql Server Adventure Works ? I don't want to create some dopey tables one by one if I can get some sample d.b., and would also like some sample PL*Sql Developer code. I can write PL Sql code but never have done anything with Java and oracle.