RE: create tbl as select *

RE: create tbl as select *

 

  

That's correct. Of, after you create the table as nologging with data,
you take a backup. Now, if you need to restore that table, you will
have the table structure and the data. Also, you can then turn
"nologging" off that table. In other words, you can make that table
start "logging" transactions.






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Martin Rosol
[mailto:oracledba-ezmlmshield-x47647596.[Email address protected]
Sent: Thursday, August 30, 2007 10:14 AM
To: LazyDBA Discussion
Subject: RE: create tbl as select *


I'm not sure if this is a stupid question, but ... :

When you use nologging, what exactly is not logged? If the transaction
isn't logged, then basically you have an inconsistent database for
restore purposes (assuming one archives and uses RMAN).

If after this table is created and populated, then later DML depended on
this data, what would happen if you tried to do a restore?


-----Original Message-----
From: Somaraju.I
[mailto:oracledba-ezmlmshield-x24834931.[Email address protected]
Sent: Thursday, August 30, 2007 5:18 AM
To: LazyDBA Discussion
Subject: RE: create tbl as select *



Use nologging also


Regards

Somaraju.I
Oracle DBA
Infotech Enterprises Limited
Ext :530, Cell # : 98494 20302


-----Original Message-----
From: Mahapatra Himanshu (*IC)
[mailto:oracledba-ezmlmshield-x28310374.[Email address protected]
Sent: Thursday, August 30, 2007 2:41 PM
To: LazyDBA Discussion
Subject: RE: create tbl as select *



Create table <New Table_name> as select /*+ parallel(a,8) */ * from
table_1 a unrecoverable;

Thanks & Regards,
Himanshu Mahapatra
Oracle DBA
Warner Bros Entertainment UK Ltd

-----Original Message-----
From: Steele Theresa
[mailto:oracledba-ezmlmshield-x73641496.[Email address protected]
Sent: 29 August 2007 20:40
To: LazyDBA Discussion
Subject: create tbl as select *

Hi All-

What is an alternative way to
do: "create table as select * from table1;"?

Can anyone send me sample code?

The problem is table1 has 1.2 million rows.

I think doing the above will create a single, enormous
transaction that doesn't commit until the end.

Thanks in advance.

Theresa Corral-Steele

MDS Global Services
Sr. Oracle Database Administrator



This email and any files transmitted with it may contain privileged or
confidential information and may be read or used only by the intended
recipient. If you are not the intended recipient of the email or any of
its attachments, please be advised that you have received this email in
error and any use, dissemination, distribution, forwarding, printing or
copying of this email or any attached files is strictly prohibited. If
you have received this email in error, please immediately purge it and
all attachments and notify the sender by reply email or contact the
sender at the number listed.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page