学习笔记

    ┌──────────────────────────────────────────────────────────────────────┐
│ • MobaXterm Personal Edition v21.3 • │
│ (SSH client, X server and network tools) │
│ │
│ ➤ SSH session to root@192.168.122.1 │
│ • Direct SSH : ✔ │
│ • SSH compression : ✔ │
│ • SSH-browser : ✔ │
│ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
│ │
│ ➤ For more info, ctrl+click on help or visit our website. │
└──────────────────────────────────────────────────────────────────────┘

Last login: Wed Nov 3 09:53:24 2021 from 192.168.122.6
[root@localhost ~]# su - oracle
Last login: Wed Nov 3 11:26:27 CST 2021 on pts/0
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ sqlplus dxb/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 15:58:42 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 15:48:03 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select * from lwt1;

A B C
---------- -------------------- --------------------
1 lwt abc
2 lwt abc
3 2222 abc
4 lwt abc
5 lwt abc
6 lwt abc
7 lwt abc
8 lwt abc
9 lwt abc
10 lwt abc
11 lwt abc

A B C
---------- -------------------- --------------------
12 lwt abc
13 lwt abc
14 lwt abc
15 lwt abc
16 lwt abc
17 lwt abc
18 lwt abc
19 lwt abc
20 lwt abc
21 lwt abc
22 lwt abc

A B C
---------- -------------------- --------------------
23 lwt abc
24 lwt abc
25 lwt abc
26 lwt abc
27 lwt abc
28 lwt abc
29 lwt abc
30 lwt abc
31 lwt abc
32 lwt abc
33 lwt abc

A B C
---------- -------------------- --------------------
34 lwt abc
35 lwt abc
36 lwt abc
37 lwt abc
38 lwt abc
39 lwt abc
40 lwt abc
41 lwt abc
42 lwt abc
43 lwt abc
44 lwt abc

A B C
---------- -------------------- --------------------
45 lwt abc
46 lwt abc
47 lwt abc
48 lwt abc
49 lwt abc
50 lwt abc
51 lwt abc
52 lwt abc
53 lwt abc
54 lwt abc
55 lwt abc

A B C
---------- -------------------- --------------------
56 lwt abc
57 lwt abc
58 lwt abc
59 lwt abc
60 lwt abc
61 lwt abc
62 lwt abc
63 lwt abc
64 lwt abc
65 lwt abc
66 lwt abc

A B C
---------- -------------------- --------------------
67 lwt abc
68 lwt abc
69 lwt abc
70 lwt abc
71 lwt abc
72 lwt abc
73 lwt abc
74 lwt abc
75 lwt abc
76 lwt abc
77 lwt abc

A B C
---------- -------------------- --------------------
78 lwt abc
79 lwt abc
80 lwt abc
81 lwt abc
82 lwt abc
83 lwt abc
84 lwt abc
85 lwt abc
86 lwt abc
87 lwt abc
88 lwt abc

A B C
---------- -------------------- --------------------
89 lwt abc
90 lwt abc
91 lwt abc
92 lwt abc
93 lwt abc
94 lwt abc
95 lwt abc
96 lwt abc
97 lwt abc
98 lwt abc
99 lwt abc

A B C
---------- -------------------- --------------------
100 lwt abc

100 rows selected.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus lwt/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:02:35 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 15:31:57 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> create table lwt3
(
c0 VARCHAR2(100) not null,
) 2 3 4 ;
)
*
ERROR at line 4:
ORA-00904: : invalid identifier


SQL> create table lwt3
(
c0 VARCHAR2(100) not null,
) 2 3 4
5
SQL>
SQL>
SQL> create table lwt3
(
c0 VARCHAR2(100) not null
); 2 3 4

Table created.

SQL> insert into lwt3 values (22222);

1 row created.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:04:21 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> create directory lwtlwt as '/Data/oradata/orcl/temp';

Directory created.

SQL> grant read,write on directory lwtlwt to public;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ expdp 'lwt/123456' directory=lwtlwt dumpfile=lwtlwt.dmp logfile=lwtlwt.log tables=lwt3

Export: Release 19.0.0.0.0 - Production on Wed Nov 3 16:07:08 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "LWT"."SYS_EXPORT_TABLE_01": lwt/******** directory=lwtlwt dumpfile=lwtlwt.dmp logfile=lwtlwt.log tables=lwt3
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "LWT"."LWT3" 5.062 KB 1 rows
Master table "LWT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for LWT.SYS_EXPORT_TABLE_01 is:
/Data/oradata/orcl/temp/lwtlwt.dmp
Job "LWT"."SYS_EXPORT_TABLE_01" successfully completed at Wed Nov 3 16:07:16 2021 elapsed 0 00:00:07

[oracle@localhost ~]$ impdp dxb/123456 directory=lwtlwt dumpfile=lwtlwt.dmp

Import: Release 19.0.0.0.0 - Production on Wed Nov 3 16:09:33 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "DXB"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "DXB"."SYS_IMPORT_FULL_01": dxb/******** directory=lwtlwt dumpfile=lwtlwt.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39151: Table "LWT"."LWT3" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "DXB"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Wed Nov 3 16:09:35 2021 elapsed 0 00:00:02

[oracle@localhost ~]$ impdp dxb/123456 directory=lwtlwt dumpfile=lwtlwt.dmp table_exists_action=replace

Import: Release 19.0.0.0.0 - Production on Wed Nov 3 16:10:15 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "DXB"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "DXB"."SYS_IMPORT_FULL_01": dxb/******** directory=lwtlwt dumpfile=lwtlwt.dmp table_exists_action=replace
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "LWT"."LWT3" 5.062 KB 1 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "DXB"."SYS_IMPORT_FULL_01" successfully completed at Wed Nov 3 16:10:25 2021 elapsed 0 00:00:10

[oracle@localhost ~]$ sqlplus dxb/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:10:47 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:10:15 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> desc dba_tables;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(128)
TABLE_NAME NOT NULL VARCHAR2(128)
TABLESPACE_NAME VARCHAR2(30)
CLUSTER_NAME VARCHAR2(128)
IOT_NAME VARCHAR2(128)
STATUS VARCHAR2(8)
PCT_FREE NUMBER
PCT_USED NUMBER
INI_TRANS NUMBER
MAX_TRANS NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
FREELISTS NUMBER
FREELIST_GROUPS NUMBER
LOGGING VARCHAR2(3)
BACKED_UP VARCHAR2(1)
NUM_ROWS NUMBER
BLOCKS NUMBER
EMPTY_BLOCKS NUMBER
AVG_SPACE NUMBER
CHAIN_CNT NUMBER
AVG_ROW_LEN NUMBER
AVG_SPACE_FREELIST_BLOCKS NUMBER
NUM_FREELIST_BLOCKS NUMBER
DEGREE VARCHAR2(40)
INSTANCES VARCHAR2(40)
CACHE VARCHAR2(20)
TABLE_LOCK VARCHAR2(8)
SAMPLE_SIZE NUMBER
LAST_ANALYZED DATE
PARTITIONED VARCHAR2(3)
IOT_TYPE VARCHAR2(12)
TEMPORARY VARCHAR2(1)
SECONDARY VARCHAR2(1)
NESTED VARCHAR2(3)
BUFFER_POOL VARCHAR2(7)
FLASH_CACHE VARCHAR2(7)
CELL_FLASH_CACHE VARCHAR2(7)
ROW_MOVEMENT VARCHAR2(8)
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
DURATION VARCHAR2(15)
SKIP_CORRUPT VARCHAR2(8)
MONITORING VARCHAR2(3)
CLUSTER_OWNER VARCHAR2(128)
DEPENDENCIES VARCHAR2(8)
COMPRESSION VARCHAR2(8)
COMPRESS_FOR VARCHAR2(30)
DROPPED VARCHAR2(3)
READ_ONLY VARCHAR2(3)
SEGMENT_CREATED VARCHAR2(3)
RESULT_CACHE VARCHAR2(7)
CLUSTERING VARCHAR2(3)
ACTIVITY_TRACKING VARCHAR2(23)
DML_TIMESTAMP VARCHAR2(25)
HAS_IDENTITY VARCHAR2(3)
CONTAINER_DATA VARCHAR2(3)
INMEMORY VARCHAR2(8)
INMEMORY_PRIORITY VARCHAR2(8)
INMEMORY_DISTRIBUTE VARCHAR2(15)
INMEMORY_COMPRESSION VARCHAR2(17)
INMEMORY_DUPLICATE VARCHAR2(13)
DEFAULT_COLLATION VARCHAR2(100)
DUPLICATED VARCHAR2(1)
SHARDED VARCHAR2(1)
EXTERNAL VARCHAR2(3)
HYBRID VARCHAR2(3)
CELLMEMORY VARCHAR2(24)
CONTAINERS_DEFAULT VARCHAR2(3)
CONTAINER_MAP VARCHAR2(3)
EXTENDED_DATA_LINK VARCHAR2(3)
EXTENDED_DATA_LINK_MAP VARCHAR2(3)
INMEMORY_SERVICE VARCHAR2(12)
INMEMORY_SERVICE_NAME VARCHAR2(1000)
CONTAINER_MAP_OBJECT VARCHAR2(3)
MEMOPTIMIZE_READ VARCHAR2(8)
MEMOPTIMIZE_WRITE VARCHAR2(8)
HAS_SENSITIVE_COLUMN VARCHAR2(3)
ADMIT_NULL VARCHAR2(3)
DATA_LINK_DML_ENABLED VARCHAR2(3)
LOGICAL_REPLICATION VARCHAR2(8)

SQL> select owner,table_name,TABLESPACE_NAME from dba_tables where table_name='LWT3';

OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
LWT
LWT3
USERS


SQL> SELECT * from lwt3;
SELECT * from lwt3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from LWT3;
select * from LWT3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:13:08 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> grant select,insert,update,drop on lwt3 to dxb;
grant select,insert,update,drop on lwt3 to dxb
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


SQL> grant select ,insert,update on lwt3 to dxb;
grant select ,insert,update on lwt3 to dxb
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus lwt/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:19:26 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:07:08 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> grant select,insert,update on lwt3 to dxb;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus lwt/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:20:03 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:19:26 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select * from lwt3;

C0
--------------------------------------------------------------------------------
22222

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus dxb/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:20:14 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:10:47 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select * from lwt3;
select * from lwt3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select owner,table_name,TABLESPACE_NAME from dba_tables where table_name='LWT3';

OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
LWT
LWT3
USERS


SQL> select * from lwt.lwt3;

C0
--------------------------------------------------------------------------------
22222

SQL> select * from dxb.lwt3;
select * from dxb.lwt3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus dxb/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:23:10 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:20:14 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select * from lwt3;
select * from lwt3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select owner,table_name,TABLESPACE_NAME from dba_tables where table_name='LWT3';

OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
LWT
LWT3
USERS


SQL> select owner,table_name,TABLESPACE_NAME from dba_tables where table_name='LWT1'
2 ;

OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
LWT
LWT1
DATA


SQL> select * from lwt3;
select * from lwt3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from LWT1;

A B C
---------- -------------------- --------------------
1 lwt abc
2 lwt abc
3 2222 abc
4 lwt abc
5 lwt abc
6 lwt abc
7 lwt abc
8 lwt abc
9 lwt abc
10 lwt abc
11 lwt abc

A B C
---------- -------------------- --------------------
12 lwt abc
13 lwt abc
14 lwt abc
15 lwt abc
16 lwt abc
17 lwt abc
18 lwt abc
19 lwt abc
20 lwt abc
21 lwt abc
22 lwt abc

A B C
---------- -------------------- --------------------
23 lwt abc
24 lwt abc
25 lwt abc
26 lwt abc
27 lwt abc
28 lwt abc
29 lwt abc
30 lwt abc
31 lwt abc
32 lwt abc
33 lwt abc

A B C
---------- -------------------- --------------------
34 lwt abc
35 lwt abc
36 lwt abc
37 lwt abc
38 lwt abc
39 lwt abc
40 lwt abc
41 lwt abc
42 lwt abc
43 lwt abc
44 lwt abc

A B C
---------- -------------------- --------------------
45 lwt abc
46 lwt abc
47 lwt abc
48 lwt abc
49 lwt abc
50 lwt abc
51 lwt abc
52 lwt abc
53 lwt abc
54 lwt abc
55 lwt abc

A B C
---------- -------------------- --------------------
56 lwt abc
57 lwt abc
58 lwt abc
59 lwt abc
60 lwt abc
61 lwt abc
62 lwt abc
63 lwt abc
64 lwt abc
65 lwt abc
66 lwt abc

A B C
---------- -------------------- --------------------
67 lwt abc
68 lwt abc
69 lwt abc
70 lwt abc
71 lwt abc
72 lwt abc
73 lwt abc
74 lwt abc
75 lwt abc
76 lwt abc
77 lwt abc

A B C
---------- -------------------- --------------------
78 lwt abc
79 lwt abc
80 lwt abc
81 lwt abc
82 lwt abc
83 lwt abc
84 lwt abc
85 lwt abc
86 lwt abc
87 lwt abc
88 lwt abc

A B C
---------- -------------------- --------------------
89 lwt abc
90 lwt abc
91 lwt abc
92 lwt abc
93 lwt abc
94 lwt abc
95 lwt abc
96 lwt abc
97 lwt abc
98 lwt abc
99 lwt abc

A B C
---------- -------------------- --------------------
100 lwt abc

100 rows selected.

SQL> select * from 'LWT3'
2 ;
select * from 'LWT3'
*
ERROR at line 1:
ORA-00903: invalid table name


SQL> SELECT * FROM LWT3;
SELECT * FROM LWT3
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus lwt/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:36:35 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:20:03 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select owner,table_name,TABLESPACE_NAME from dba_tables where table_name='DXB1';


OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
DXB
DXB1
DATA


SQL> SQL> SELECT * FROM SYS_IMPORT_FULL_01;
SELECT * FROM SYS_IMPORT_FULL_01
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> EXIT
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ sqlplus dxb/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:38:14 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:23:10 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> EXIT
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@localhost ~]$ select c0 from SYS_IMPORT_FULL_01；se'le
-bash: syntax error near unexpected token `from'
[oracle@localhost ~]$ sqlplus dxb/123456

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 3 16:39:54 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Nov 03 2021 16:38:14 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select c0 from SYS_IMPORT_FULL_01；
2 SYS_IMPORT_FULL_01;
select c0 from SYS_IMPORT_FULL_01；
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>




create table lwt4
(
c0 VARCHAR2(100) not null
)