SQL Language (MOSC)

MOSC Banner

Create table as select from...with partition dont work

edited Oct 5, 2011 1:50AM in SQL Language (MOSC) 4 commentsAnswered
Hi!11.2.0.2 Linux x64

Im trying this:

create table user.bugghunt as select * from user.mytable1 partition (20110101);

The table gets created but not the partition.

Why not?

Regards
U

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