Home » SQL & PL/SQL » SQL & PL/SQL » "Create table from another Table" issue (Oracle)
"Create table from another Table" issue [message #434724] Thu, 10 December 2009 06:54 Go to next message
allen_k85
Messages: 2
Registered: December 2009
Junior Member
hey everyone,
below is my query..

create table newtablename as
select * from oldtablename
tablespace temp

in which scenario, the above statement wont work in oracle..would be grateful if anyone can reply to this.


Allen Cool
Re: "Create table from another Table" issue [message #434727 is a reply to message #434724] Thu, 10 December 2009 07:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If the target tablespace is a temporary one.
If the source table contains a long.

What is my reward?

Regards
Michel
Re: "Create table from another Table" issue [message #434729 is a reply to message #434724] Thu, 10 December 2009 07:11 Go to previous messageGo to next message
allen_k85
Messages: 2
Registered: December 2009
Junior Member
Reward???

well,all i can say is "THANK U FOR REPLYING"
Re: "Create table from another Table" issue [message #434736 is a reply to message #434729] Thu, 10 December 2009 08:02 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Was just kidding as it seems to be an interview question.

Regards
Michel
Previous Topic: ORA-14551 and INSERT INTO
Next Topic: exec dbms_mview.refresh('mviewname','c','atomic_refresh=>FALSE) is giving error
Goto Forum:
  


Current Time: Mon Dec 05 08:47:58 CST 2016

Total time taken to generate the page: 0.09186 seconds