Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Swapping data out of a partition

Posted on 2008-06-19
4
Medium Priority
?
387 Views
Last Modified: 2013-12-18
Hello,
I have a partitioned table in my production system .
I need to move the data out of table which os older than January 1/1/2008 .
The tables have 2 other child tables .
How would I proceed ?
0
Comment
Question by:gyans
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 21828557
what do you mean by "swapping"  that sounds like you want to put the data somewhere else and put data from the somewhere else into your partition.

If so,  what is the "somewhere else"  and what is the data there?

what does your table look like, what are the child tables?  What do you want to do with the child table data?
Are there cascading contraints between the parent and children?
0
 
LVL 1

Author Comment

by:gyans
ID: 21864751
Thanks for replying .
I am rephrasing my question.
I have 3 tables in production  which have  around  200 partitions  each beginning from 2003.
I would like to move any data from all 3 tables onto a different schema and different tables that is prior to 1/1/2008.
What would be the best way ?
thanks you
0
 
LVL 1

Author Closing Comment

by:gyans
ID: 31468908
Question was not answered so dont want to allocate any points .
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 22233292
you could have requested a delete rather than accepting the answer.  I'm sorry I missed your followup.

anyway, for what you are trying to do...

use dynamic sql to generate code of the form...

create table new_schema.new_table_name as select * from old_schema.old_table where data_date_column >= to_date('20030101','yyymmdd')



0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

661 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question