 |
 |
Archives of the TeradataForum
Message Posted: Thu, 27 Jul 2006 @ 16:07:26 GMT
| Subj: | | Re: NOLOGGING documentation |
| |
| From: | | Dieter Noeth |
Bill Garland wrote:
| | I have heard that there is a NOLOGGING keyword (used in conjunction with CREATE TABLE and index creation. However, I am not able to track
down any documentation as to whether it actually exists and how it is used. | |
NOLOGGING is Oracle syntax.
In Teradata there's a NO LOG option, which switches off Transient Journal, but it's only for temporary tables.
You probably know, what happens to your data if there must to be a rollback without journal? It's corrupted...
| | I guess my broader question would be to determine if there was a means to stop the logging of table inserts when I need to load large
files to tables on Teradata. | |
How do you load?
Why don't you use one of the existing load tools, e.g. MultiLoad?
Dieter
| |
