SQL*Plus (MOSC)

MOSC Banner

CREATE TABLE AS CREATE TABLE NAME PREFIXED WITH "?"

in SQL*Plus (MOSC) 3 commentsAnswered ✓

06:57:39 SQL> create table ORDERS_STAGING_BAK as (select * from ORDERS_STAGING);

Table created.

Elapsed: 00:10:03.13

07:07:50 SQL> 07:07:50 SQL> 07:07:50 SQL>

07:10:19 SQL> desc ORDERS_STAGING_BAK

ERROR:

ORA-04043: object ORDERS_STAGING_BAK does not exist


07:10:51 SQL> select object_name from user_objects where object_name like '%ORDERS_STAGING_BAK%';


OBJECT_NAME

--------------------------------------------------------------------------------

?ORDERS_STAGING_BAK


Elapsed: 00:00:00.03

07:11:25 SQL>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center