Oracle Database Discussions

I am the only Oracle dba(newbie) in my work place. when i try to rename a table called ATREPORT.INCOME when i log on sysdba its tells me the table doesn't exist. but when i log on as the schema-owner (ATREPORT) and rename the table, their is no problem. is there anything I'm doing wrong.

Also, under this same schema anytIME I try to INSERT into a table i create fromCTAS, the code would run properly but the data won't appear in table, So i have to re-create the table and insert into in with the same code and it works.

Can anyone pls advise me if there is anything i'm doing wrong