Syntax highlighter error on CREATE TABLE

Toad for Oracle - Beta
1

Howdy,

Similar to Syntax highlight error on CREATE USER this statement is highlighted as invalid when it isn't (Oracle v12.2 and up):

CREATE TABLE new_blah TABLESPACE users FOR EXCHANGE WITH old_blah;

Thanks!
Rich

2

Blah blah blah

2 Likes
3

Using 21:

Oracle says: ORA-00966: missing TABLE keyword.
Parser says: token: old_blah, expecting: TABLE.

The 21 syntax is: FOR EXCHANGE WITH TABLE mytable.

Are you really sure 12.2 accepts it? (can't test is here for now)

Thanks,
Andre

4

Hey Andre!

Yes, my powers of visual copy/paste between two PCs failed miserably there. The corrected statement is:

CREATE TABLE new_blah TABLESPACE users FOR EXCHANGE WITH TABLE old_blah;

I do get the parse error on it using the 19.3 full Oracle client (I need proxy connections, so no super cool clientless connections for me), connecting to a 19.18 database.

As this is a test DB, I just reran it and it completed successfully in 0.071s as evidenced in the Spool SQL output. Obviously the "old_blah" table existed prior to executing this statement.

There's also a blog post about this, using the same syntax:

Thanks much!
Rich

5

Hi Rich,

Now we have a valid statement that Toad parser does not like ...
Okay, just fixed. (QP-4076)

Thanks!
Andre

1 Like