Home » SQL & PL/SQL » SQL & PL/SQL » How to create table with storage options
How to create table with storage options [message #10463] Sat, 24 January 2004 05:11 Go to next message
Sudeep Mohile
Messages: 2
Registered: January 2004
Junior Member
Hi,

I am trying to create a table from an existing table with storage option.

create table secondtable as select * from firsttable;

I want to add the storage clause too. However, it errors out. Is there any way to handle this?

thanks,

SM

Report message to a moderator

Re: How to create table with storage options [message #10465 is a reply to message #10463] Sat, 24 January 2004 05:41 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
 
thiru@9.2.0:SQL>create table secondtable storage(initial 1m next 1m) as select * from scott.emp;

Table created.


Having said that, pls read this too
Storage

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: SQL server or ORACLE
Next Topic: Conditional Insert???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 08:22:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.