Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> moving data
Hi all,
Back on the list after being away for a while. I'm currently at a new client where things are to done yesterday (as usual).
We must move data (1Gig) from a staging area to the
final area, tables have integrity constraints and
tables contain CLOB datatypes.
The 2 areas are in 2 different schemas (but I can
change that). Oracle 817/Sun
Before testing, I see 4 ways to do it :
1. Exchange partition
2. Disable constraint, truncate/insert, enable
constraint
3. Create new partition, insert (append), drop
partition
4. CTAS, create constraints, rename tables
Been there ?
Currently at Caprion Pharmaceuticals
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 05 2002 - 00:08:34 CST
![]() |
![]() |