Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Info:
Ricavare lista oggetti modificati in un dato intervallo di tempo
Oracle...
Script:
Esempio schema per analisi sui processi e parametri del db
Unix...
Tip:
Rimuovere un file in Unix / Delete a file
PLSQL...
Script:
Leggere un file di testo
Oracle...
Tip:
TWO_TASK
Oracle...
Faq:
Which chars in table and column names?
Shell scripting...
Script:
while do loop
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
Php Funzione mail()
XPath is a language for addressing parts of an XML document.
It is designed to be used by XSLT and XPointer.
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
|
Oracle
Home >Oracle > Drop and truncate partition data and keeping valid indexes and other objects
Partitioned tables are very big tables, this is why you do partitioning. Dropping or truncating partitions affects indexes: sometimes it takes very long, too much time to rebuild those indexes (based on the whole table). In oracle 10g you can use the clause update indexes while you drop or truncate partitions. When you use update indexes the indexes on the table will be stay VALID, it will take a little longer but it will not be necessary rebuild the indexes. I suggest to monitoring always the status of indexes and other dependent objects. As a matter of fact, while truncating or dropping partition objects such trigger or synonym may become invalid. So be aware of it, and ready to recompile them.
SQL> select * from v$version;
BANNER
------------------------------------------------------------ Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi -- drop partition SQL> alter table CDR DROP PARTITION PART_2009_05 UPDATE INDEXES ; -- truncate partition SQL> alter table CDR TRUNCATE PARTITION PART_2009_05 UPDATE INDEXES ; Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Codici errore ![]() ![]() ![]() ![]() ![]() |
Cerca
Oracle...
Info:
Alter table
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
Oracle...
Info:
Oggetto directory
Oracle...
Citazioni:
Designing an efficient Schema ...
Oracle...
Definizioni:
Schema
Oracle...
Definizioni:
Scalar Subquery
Shell scripting...
Script:
Pulire i file provenienti da ambieti dos/ windoes da caratteri sporchi
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |