http://netvouz.com/MondoTofu/tag/table?feed=rss MondoTofu's bookmarks tagged "table" on Netvouz https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4098126300346150794 Updating a large table with partition exchange. Oracle > Internals MondoTofu Tue, 06 Oct 2015 21:31:40 GMT https://community.oracle.com/thread/682170?tstart=0 SELECT named, object_path, comments FROM schema_export_objects WHERE object_path LIKE 'JOB%' Named Object_path Comments NULL JOB Jobs in the selected schemas. If the Named column=Y, you can exclude the object type and if its null,you cannot. Oracle > DB 11g MondoTofu Fri, 02 May 2014 14:33:20 GMT http://www.oracle-developer.net/display.php?id=429 Excerpt on pipelined table functions from Feuerstein book on PL/SQL Oracle > DB 11g MondoTofu Fri, 28 Dec 2012 20:10:09 GMT https://blogs.oracle.com/optimizer/entry/incremental_statistics_maintenance_what_statistics strategies for gathering statistics DML new feature 11g; helpful for partitioned tables Oracle > DB 11g MondoTofu Sun, 27 Apr 2014 01:39:24 GMT http://amit7oracledba.blogspot.com/2013/03/move-partitioned-tables-to-different.html Changing the default tablespace of Partition table. Now new partitions will be created in the new default tablespace, but old partitions will remain in the old default tablespace :- SQL> alter table partition modify default attributes tablespace users; Table altered. Oracle > DB 11g MondoTofu Thu, 26 Jan 2017 17:20:02 GMT http://www.sqlpanda.com/2013/02/sql-access-advisor-saa.html SAA is tuning base on the single SQL statement but the SAA consider the overall system. For example, when SAA recommend to create the index on the table. The SAA would also consider the index could cause the impact for other query. Oracle > Optimization MondoTofu Tue, 30 Aug 2016 13:21:02 GMT http://etutorials.org/SQL/Mastering+Oracle+SQL/Chapter+10.+Partitioning/10.5+Specifying+Partitions/ SUBPARTITION clause to focus on a single subpartition of the table. Oracle > DB 11g MondoTofu Tue, 02 Jun 2015 20:39:30 GMT http://docs.oracle.com/cd/B14117_01/server.101/b10825/ldr_cases.htm#i1006686 including loading data into multiple tables Oracle MondoTofu Fri, 10 Jan 2014 19:33:01 GMT http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:210612357425 SQL, PL/SQL, table functions, bind variables, variable content Oracle > PL/SQL 11g MondoTofu Wed, 19 Dec 2012 16:48:35 GMT http://www.ciobriefings.com/Publications/WhitePapers/DesigningtheStarSchemaDatabase/tabid/101/Default.aspx data warehouse article referencing tall skinny Data Management MondoTofu Wed, 12 Dec 2012 14:54:49 GMT