Partitioning existing tables

Author: asktom.oracle.com | Published: 21st May 2008 | Visited: 48 times | Add Comment
Filed in: Oracle FAQ

I am attempting to partition a Table T1 with existing data. Table T1 is as follows: COLUMN DATATYPE ----------------- COLUMN1 NUMBER PK COLUMN2 NUMBER COLUMN3 NUMBER I am using this approach: 1- ALTER TABLE T1 RENAME TO T1_TEMP 2- CREAT...

Read Article

Sponsored Links

• Querying SQLServer tables from within an Oracle session Dear Tom; I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like: <CODE> select * from t@sql_server_link </CODE> May you redirect me to the appropriate documentati ...

• ODP.NET - Populating a Dataset with Multiple Data Tables ODP.NET - Populating a Dataset with Multiple Data Tables Now, let us add more than one data table into a dataset The following code retrieves a list of department details into a data table named Departments and another list of employee details into a data table named Employees: Visit http://www.exf ...

• Partitioning tables with unequal partitions. Hi Tom, We have data coming into our application from different entities/agencies and being loaded into several different tables. Each transmission contains data that belongs to a unique entity. We can also receive a new transmission for each ent ...

• The easy route to tables, rollovers, and links View a series of video tutorials to learn how to lay out tables, create rollovers and links, and preview pages in GoLive ...

• Designing with CSS - Part 3: Creating Your First Design Without Tables Create a CSS-positioned layout of a fixed-width page with a horizontal navigation sys ...

• Simple way to implement database driven Advance Search Engine to search data in many tables Way to search record in relational tables to get search count on a search st ...

• Article :: Defining and Working with Fields and Tables in FileMaker 9 Learn techniques to make your FileMaker Pro databases meaningful to yourself and others for the long period of time that they may be in ...

• List the tables with DML Dependencies Using DBA_DEPENDENCIES, we can find all the dependents inside the db (procedures, triggers, packages, etc) for a given table. But now my developers want to know where (inside the db) a given table is inserted/updated/deleted - to discover that, I wa ...

• A Naming Scheme for Database Tables and Fields This article presents a naming scheme for database tables and fie ...

Next: Querying SQLServer tables from within an Oracle session