Oracle Database Discussions

I run SQLPLUS on windows and use sqlplus.
conn sys as sysdba. Fine
Next I want see tables under sysdba
I create table and I can do SELECT * from table. SQL shows me output.
But I can`t see tables
SELECT table_name FROM user_tables;
SELECT table_name FROM all_tables;
SELECT table_name FROM dba_tables;
SELECT * from user_objects where object_type = 'TABLE';

SQLPLUS:ORA-00942: table or view does not exist.

How repair it?
I created earlier DB and could do that but I want repair this database.

And there was problems with db mynewdb1, maybe corrupt

recover database until cancel using backup controlfile;
ORA-279 signalled during: ALTER DATABASE RECOVER database until cancel using backup controlfile ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_10\O1_MF_1_1_%U_.ARC
Fri May 10 21:06:30 2013
Errors with log C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_10\O1_MF_1_1_%U_.ARC
Errors in file C:\APP\STR\diag\rdbms\mynewdb1\mynewdb1\trace\mynewdb1_pr00_9920.trc:
ORA-00308: cannot open archived log 'C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_10\O1_MF_1_1_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...





CREATE CONTROLFILE REUSE DATABASE MYNEWDB1 RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Errors in file C:\APP\STR\diag\rdbms\mynewdb1\mynewdb1\trace\mynewdb1_ora_8588.trc:
ORA-01565: error in identifying file '%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE MYNEWDB1 RESETLOGS...

Edited by: 1005307 on 10.05.2013 18:08