SQL Language (MOSC)

MOSC Banner

Synonym for tablespace in DDL

edited Nov 19, 2019 9:41AM in SQL Language (MOSC) 2 commentsAnswered ✓

I am looking for a way to do the following.

- Create a synonym for the tablespace and use it in the DDL statements.

for example, something like:

1.

create or replace synonym tsd for ts_data; -- synonym for tablespacecreate table t (i varchar2(10)) tablespace tsd;

or

2.

create or replace synonym tsi for ts_index; -- synonym for tablespacecreate table tt (i varchar2(10) primary key using index tablespace tsi);

Version:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

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