SQL> connect system/manager@fuju Connected. SQL> desc dba_tablespaces; Name Null? Type ------------------------------- -------- ---- TABLESPACE_NAME NOT NULL VARCHAR2(30) INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NOT NULL NUMBER MAX_EXTENTS NOT NULL NUMBER PCT_INCREASE NOT NULL NUMBER MIN_EXTLEN NUMBER STATUS VARCHAR2(9) CONTENTS VARCHAR2(9) LOGGING VARCHAR2(9) SQL> select tablestacename, status from dbatablespaces; select tablestacename, status from dbatablespaces * ERROR at line 1: ORA-00942: table or view does not exist SQL> select tablespace_name, status from dba_tablespaces; TABLESPACE_NAME STATUS ------------------------------ --------- SYSTEM ONLINE RBS ONLINE USR ONLINE TEMPORARY ONLINE INDX ONLINE DES2K ONLINE 6 rows selected. SQL> desc dba_users; Name Null? Type ------------------------------- -------- ---- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) SQL> select username, created from dba_users; USERNAME CREATED ------------------------------ --------- SYS 09-DEC-99 SYSTEM 09-DEC-99 DBSNMP 09-DEC-99 REPOS 09-DEC-99 OEM16 10-JAN-00 TUTORIAL 11-DEC-99 SCOTT 04-JAN-00 NICOLE 08-JAN-00 X02 03-JUN-00 MOS 21-JAN-00 WMOS 12-MAR-00 NEW2 11-MAR-00 NARISA 19-MAR-00 X03 27-JUN-00 PHPHOO 09-DEC-00 15 rows selected. SQL> create user teddy identified by tiger default tablespace usr 2 temporary tablespace temporary; User created. SQL> grant connect, resource to teddy 2 ; Grant succeeded. SQL> select username, created from dba_users; USERNAME CREATED ------------------------------ --------- SYS 09-DEC-99 SYSTEM 09-DEC-99 DBSNMP 09-DEC-99 REPOS 09-DEC-99 OEM16 10-JAN-00 TUTORIAL 11-DEC-99 SCOTT 04-JAN-00 NICOLE 08-JAN-00 X02 03-JUN-00 MOS 21-JAN-00 WMOS 12-MAR-00 NEW2 11-MAR-00 NARISA 19-MAR-00 X03 27-JUN-00 PHPHOO 09-DEC-00 TEDDY 31-DEC-00 16 rows selected. SQL> connect teddy/tiger@fuju; Connected. SQL> select * from tab; no rows selected SQL> @D:\Demobld.sql Building demonstration tables. Please wait. DROP TABLE EMP * ERROR at line 1: ORA-00942: table or view does not exist DROP TABLE DEPT * ERROR at line 1: ORA-00942: table or view does not exist DROP TABLE BONUS * ERROR at line 1: ORA-00942: table or view does not exist DROP TABLE SALGRADE * ERROR at line 1: ORA-00942: table or view does not exist DROP TABLE DUMMY * ERROR at line 1: ORA-00942: table or view does not exist SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- --------- BONUS TABLE DEPT TABLE DUMMY TABLE EMP TABLE SALGRADE TABLE SQL> show user USER is "TEDDY" SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO --------- ---------- --------- --------- --------- --------- --------- --------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 09-DEC-82 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 12-JAN-83 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 14 rows selected. SQL>