Clive_S wrote:As you have been told several times before, the quality of help you receive here will be greatly improved, and time to resolution greatly reduced, if you will quit describing what you think you did and the response you got, and show us what you actually did and the response you actually got. One more time: work at a sqlplus command prompt, copy your commands and responses, and paste that in your postings. We are not looking over your shoulder, we cannot see over your shoulder to see all of the steps you describe, to see if you mis-keyed something or you mis-intrpreted, mis-represented what you thought you did.
I created table test in ME.
SQL> create table test (empnname varchar2(30),empnum number);
Then ran select table_name from user_tables;
Got error no table or view??
Is there a problem with the ME user???
CREATE USEr ME
DEFAULT TABLESPACE USERS;