Database DataWarehousing (MOSC)

MOSC Banner

Question on creating partition table with "create table as select"

edited Mar 7, 2011 3:44AM in Database DataWarehousing (MOSC) 4 commentsAnswered
 Hi, guys,

A question, if i'd like to create a partition table with create table as select statement. how do i do that?

For example, there's a partition table TABLE_A. I am trying to create the same table structure table TABLE_B, what the syntax would be to create the TABLE_B?

Thanks

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