• Ask Tom "Merge syntax to update selected partitions only"
  Updating a large table with partition exchange.
  in Oracle > Internals with dataobj dataobj_to_partition exchange function large partition table updating with
• Data Pump - How to avoid exporting/importing jobs
  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.
  in Oracle > DB 11g with database database_export_objects datapump exclude expdp export job named null schema schema_export_objects table table_export_objects
• improving performance with pipelined table functions
  Excerpt on pipelined table functions from Feuerstein book on PL/SQL
  in Oracle > DB 11g with billington developer functions merge object oracle performance pipelined plsql table type
• Incremental Statistics Maintenance – what statistics will be gathered after DML occurs on the table? (Oracle Optimizer)
  strategies for gathering statistics DML new feature 11g; helpful for partitioned tables
  in Oracle > DB 11g with 11g blog gathering incremental oracle partitioned statistics table tables
• Oracle Database: How to move partitioned tables to different tablespace
  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.
  in Oracle > DB 11g with a alter attributes cannot different modify move object on operation ora-14511: partition partitioned partitions perform table tablespace to
• SQL Access Advisor (SAA) | SQL Panda
  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.
  in Oracle > Optimization with access advisor query recommend saa sql statement system table tuning
• 10.5 Specifying Partitions :: Chapter 10. Partitioning :: Mastering Oracle SQL :: SQL :: eTutorials.org
  SUBPARTITION clause to focus on a single subpartition of the table.
  in Oracle > DB 11g with 11g 11gr2 clause focus oracle partition partition_extension single subpartition table
• 12 SQL*Loader Case Studies
  including loading data into multiple tables
  in Oracle with case example loader multi sql sqlldr studies study table
• Ask Tom "How can I do a variable "in list""
  SQL, PL/SQL, table functions, bind variables, variable content
  in Oracle > PL/SQL 11g with bind content functions plsql sql table variable variables
• Designing the Star Schema Database
  data warehouse article referencing tall skinny
  in Data Management with aggregation data fact schema skinny star table tables tall warehouse
• Oracle 11g Flashback examples | Matthias Hoys
  FLASHBACK TABLE matthiash TO TIMESTAMP TO_TIMESTAMP('2013-05-03 13:00:00', 'YYYY-MM-DD HH24:MI:SS');
  in Oracle with 11g flashback oracle table timestamp to_timestamp yyyy-mm-dd
• Reclaiming Wasted Space Oracle 11g Viewing Segment Advisor Results
  Segment space advisor, DBA_RECOMMENDATIONS shrink compact savings
  in Oracle > DB 11g with actions advisor compact dba_recommendations index management oem segment segments shrink space table tablespaces views
• A Periodic Table of Visualization Methods
  in Visualization with methods periodic table visualization by 25 users
• Another INSERT BLOB into a table question
  in Oracle > Blob with blob insert oracle table
• Free as in Freedom
  Table of Contents
  in GNU/Linux with table
• How to move IOT related table, index and overflow segment to another tablespace « Oracle & Unix
  in Oracle with index iot move oracle overflow segment table tablespace
• Oracle/PLSQL: Retrieve the value of a LONG field
  I have a table in Oracle that contains a field with the data type of LONG.
  in Oracle with contains data oracle table type
• Table of Contents
  in Oracle > AS 10g > AppServerInstall with appserverinstall oracle table
• truncate table for DB2 - differences - IBM DB2
  truncate table for DB2 - differences. Get answers to your questions in our IBM DB2 forum.
  in DB2 Topics with answers db2 forum ibm questions table topics truncate

table from all users