Oracle Database Discussions

Dear DBA's,

I am studying towards the OCA and working through the SQL Fundamentals I Exam guide text book by John Watson and Roopesh Ramklass. I have a problem with accessing the HR Schema tables in SQL Developer. I can get connected to the HR schema but no information is available when i click on the + sign next to the "Tables (filtered)" link in SQL Developer under Human Resources - BTW (I've downloaded Oracle 11G)

Please help, I've tried the following already;

1. Downloaded the HR Schema sample scripts again
2. Resetting the Sample schema with this syntax in SQL PLUS - @?/demo/schema/mksample systempwd syspwd hrpwd oepwd pmpwd ixpwd shpwd bipwd default_tablespace temp_tablespace log_file_directory/
3. I have no Master script file so I cant recreate the sample scripts

I've been reading forums and trying to Google but I am too new at this and just can't get the HR schema to display all the information in SQL Developer. Please help as I really badly need to practice the exercises in the text book.

Any help to resolve this will be greatly appreciated.

Ali

Edited by: 942730 on Jun 26, 2012 1:15 AM