Oracle 18C New Feature Private Temporary Table

Рет қаралды 25,107

Күн бұрын

Пікірлер: 38

@SivaAcademy 6 жыл бұрын

A typo error in the slide, Please read as "ON COMMIT DROP DEFINITION" instead of "ON COMMIT DELETE DEFINITION" Thanks Prem for pointing it out.

@arijitroy7253 2 жыл бұрын

Thnx a lot. But this naming convention governed by that parameter seemed little tough! Moreover, if multiple sessions are creating PTT by same name n structure, then wat and how dba_tables going to store/maintain the metadata session wise separately?

@harendrajadon1980 2 жыл бұрын

Any tutorials on oracle forms a d reports. Please share links if any. Thanks

@VarasPassion 3 жыл бұрын

Explained very well...thank you dear :)

@SivaAcademy 3 жыл бұрын

Welcome bro

@tejalpatkar2511 3 жыл бұрын

In 19C facing issue for GTT table Can you please Guide

@raghud541 2 жыл бұрын

So Global temp tables are like normal tables which once created will be available always, but only data will be private to the sessions?

@kunalkumar57 2 жыл бұрын

SQL> create private temporary table t(sno number) on commit preserve definition; create private temporary table t(sno number) on commit preserve definition * ERROR at line 1: ORA-00903: invalid table name

@premgona5587 6 жыл бұрын

I found a typo in the video.. Just correcting it... The two modes of Private temp tables are, 1) on commit PRESERVE definition - session specific 2) on commit DROP definition - table will be dropped automatically, once the commit or rollback issues

@SivaAcademy 6 жыл бұрын

Thanks for informing. will try to correct it.

@premgona5587 6 жыл бұрын

I have tried in the DB with DELETE but it didn't work... It worked with DROP option...

@SivaAcademy 6 жыл бұрын

I hope you are trying in 18C DB right?

@SivaAcademy 6 жыл бұрын

Send me yours scripts and steps you tried to my mail id, I will check and let you know tomorrow. ( mail to siva.k.academy@gmail.com)

@premgona5587 6 жыл бұрын

I have tried in oracle website... LIVESQL... create private temporary table test_18c_private_temp_table (id number, name varchar(10)) on delete drop definition; insert into test_18c_private_temp_table Values(101,'Prem'); select * from test_18c_private_temp_table; commit; Again, if we try to query the table it will throw an error saying "table or view doesn't exists".

@sadhusehrawat9501 3 жыл бұрын

Isn't Private Temporary Table very much similar to Local Temporary Table of 8i?

@12ravindrareddy 3 жыл бұрын

Can we create index on GTT?

@abhishekrahagude2707 2 жыл бұрын

Siva could you please provide 2-3 use case for temporary table.

@letopizdetz 3 ай бұрын

I know it's a year too late, but temporary tables cut down on execution time. sometimes 5-10x. Example: You have to filter 1mil rows out of 1billion rows with 3 joins and 10 where clauses... and another million rows from a different source, and then inner join them. If you break the script into 2 segments and dump both large selects into 2 temp tables and then perform the final join and filtering, it reduces execution time.