RE: Exporting a partition with transport tablespace
Your brain is getting full. You should stop studying so much. See what it does to you? -Original Message- Yep, I didn't remember the exact clause in the exchange partition syntax. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Exporting a partition with transport tablespace
Probably he needs to set: pga_aggregate_target :) Regards, Waleed -Original Message- Sent: Monday, December 29, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Your brain is getting full. You should stop studying so much. See what it does to you? -Original Message- Yep, I didn't remember the exact clause in the exchange partition syntax. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
Yes, that's why I went to a memory improvement training few weeks ago ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 29, 2003 6:59 PM Your brain is getting full. You should stop studying so much. See what it does to you? -Original Message- Yep, I didn't remember the exact clause in the exchange partition syntax. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
Hope it improved your hit ratio :) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 29, 2003 1:59 PM Yes, that's why I went to a memory improvement training few weeks ago ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 29, 2003 6:59 PM Your brain is getting full. You should stop studying so much. See what it does to you? -Original Message- Yep, I didn't remember the exact clause in the exchange partition syntax. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
The need to set primary and unique constraints to NOVALIDATE when doing an exchange partition. (It still doesn't help with problems of parent/child tables when dropping partitions though). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 11:49 PM Jonathan, Which exact behaviour were you talking about? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 11:34 PM Good news ! That bug has been fixed in 9.2.0.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
Thanks, I haven't hit this problem before. Actually, in my post I recommended to use novalidate option for exchanging required partition back from temporary transport table, that way Oracle won't check the contents in the partition (should be used only when this partition doesn't change in the meantime). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 12:10 PM The need to set primary and unique constraints to NOVALIDATE when doing an exchange partition. (It still doesn't help with problems of parent/child tables when dropping partitions though). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 11:49 PM Jonathan, Which exact behaviour were you talking about? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 11:34 PM Good news ! That bug has been fixed in 9.2.0.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
So your 'novalidate' referred to the without validation clause of exchange; I thought you were referring to the workaround for uk/pk exchanges where even if you did including indexes without validate on the exchange, Oracle still did a horrendous check of the UK and PK constraints by doing a massive MINUS and INTERSECTION across the entire partitioned table. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 11:34 AM Thanks, I haven't hit this problem before. Actually, in my post I recommended to use novalidate option for exchanging required partition back from temporary transport table, that way Oracle won't check the contents in the partition (should be used only when this partition doesn't change in the meantime). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
Yep, I didn't remember the exact clause in the exchange partition syntax. Tanel. So your 'novalidate' referred to the without validation clause of exchange; I thought you were referring to the workaround for uk/pk exchanges where even if you did including indexes without validate on the exchange, Oracle still did a horrendous check of the UK and PK constraints by doing a massive MINUS and INTERSECTION across the entire partitioned table. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 28, 2003 11:34 AM Thanks, I haven't hit this problem before. Actually, in my post I recommended to use novalidate option for exchanging required partition back from temporary transport table, that way Oracle won't check the contents in the partition (should be used only when this partition doesn't change in the meantime). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
Title: Exporting a partition with transport tablespace
Make sure that you use novalidate and exchange
indexes as well - that way Oracle won't make unnecessary work.
Also, you should export the metadata at the time
when required partitions are exchanged to "transport tables".
Tanel.
- Original Message -
From:
Igor
Neyman
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 22, 2003 10:49
PM
Subject: RE: Exporting a partition with
transport tablespace
You could create new
table in transportable tablespace, exchange data with the partition you want
to export, move transportable tablespace file to the destination system,
exchange data back from the table into desired partition.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
NGUYEN Philippe (Cetelem)Sent: Monday, December 22, 2003 10:34
AMTo: Multiple recipients of
list ORACLE-LSubject:
Exporting a partition with transport tablespace
Hi list, is it
possible to export a partition with the transportable tablespace feature
? My partition is over 8
Go.
Here my statements , thank you in
advance !
SQLexec
sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from
sys.transport_set_violations;
VIOLATIONS
Partitioned table
TOPASE.HISTO_DOSSIER is partially contained in the transportab
le set: check table partitions by
querying sys.dba_tab_partitions
Default Partition (Table)
Tablespace HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n ot
contained in transportable set
Default Partition (Table)
Tablespace HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n ot
contained in transportable set
Default Partition (Table)
Tablespace HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n ot
contained in transportable set
Re: Exporting a partition with transport tablespace
Good news ! That bug has been fixed in 9.2.0.4 Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 8:59 PM Exporting a partition with transport tablespaceMake sure that you use novalidate and exchange indexes as well - that way Oracle won't make unnecessary work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
Jonathan, Which exact behaviour were you talking about? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 27, 2003 11:34 PM Good news ! That bug has been fixed in 9.2.0.4 Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: Exporting a partition with transport tablespace
transportable tablespaces need to be totally self-contained. everything that is being
transported has to be in that tablespace. it doesnt matter if its a different
datafile.
you probably have your partitions in seperate tablespaces? or am i wrong?
From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 10:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace
feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from sys.transport_set_violations;
VIOLATIONS
Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the
transportab
le set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Title: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from sys.transport_set_violations;
VIOLATIONS
Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the transportab
le set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set
Re: Exporting a partition with transport tablespace
wait or are you just trying to transport 1 partition?
i think you have to do regular export and import.
From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 10:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace
feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from sys.transport_set_violations;
VIOLATIONS
Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the
transportab
le set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Title: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from sys.transport_set_violations;
VIOLATIONS
Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the transportab
le set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n
ot contained in transportable set
Re: Exporting a partition with transport tablespace
Title: Exporting a partition with transport tablespace
No it's not. However, you could simply exchange the
partition with a table and then export the tablespace.
For instance,
ALTER TABLE HISTO_DOSSIEREXCHANGE PARTITION
part1 WITH TABLE HISTO_DOSSIER_part1;
Then export the tablespace. Make sure you do the
same for any local indexes, too.
HTH.
Arup Nanda
- Original Message -
From:
NGUYEN Philippe (Cetelem)
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 22, 2003 10:34
AM
Subject: Exporting a partition with
transport tablespace
Hi list, is it
possible to export a partition with the transportable tablespace feature
? My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec
sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from
sys.transport_set_violations;
VIOLATIONS
Partitioned table TOPASE.HISTO_DOSSIER is
partially contained in the transportab le
set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace
HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n ot contained in transportable set
Default Partition (Table) Tablespace
HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n ot contained in transportable set
Default Partition (Table) Tablespace
HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n ot contained in transportable set
RE: Exporting a partition with transport tablespace
Title: RE: Exporting a partition with transport tablespace
Yes, my partitions are in separate tablespaces
so do I have to export all the tablespaces concerned ?
wich solution do you use ? each partition is over 8 Go so should I use common export command to backup only one tablespace ?
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]De la part de
[EMAIL PROTECTED]
Envoyé : lundi 22 décembre 2003 17:09
À : Multiple recipients of list ORACLE-L
Objet : Re: Exporting a partition with transport tablespace
transportable tablespaces need to be totally self-contained. everything that is being transported has to be in that tablespace. it doesnt matter if its a different datafile.
you probably have your partitions in seperate tablespaces? or am i wrong?
From: NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 10:34:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Exporting a partition with transport tablespace
Hi list,
is it possible to export a partition with the transportable tablespace
feature ?
My partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL select * from sys.transport_set_violations;
VIOLATIONS
Partitioned table TOPASE.HISTO_DOSSIER is partially contained in the
transportab
le set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace HISTO_DOSSIER_P2_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P3_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
Default Partition (Table) Tablespace HISTO_DOSSIER_P4_MD_TAB for
HISTO_DOSSIER n
ot contained in transportable set
RE: Exporting a partition with transport tablespace
Title: Exporting a partition with transport tablespace
You could create new table in
transportable tablespace, exchange data with the partition you want to export, move
transportable tablespace file to the destination system, exchange data back
from the table into desired partition.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of NGUYEN
Philippe (Cetelem)
Sent: Monday, December 22, 2003
10:34 AM
To: Multiple recipients of list
ORACLE-L
Subject: Exporting a partition
with transport tablespace
Hi list,
is it
possible to export a partition with the transportable tablespace feature ?
My
partition is over 8 Go.
Here my statements , thank you in advance !
SQLexec
sys.dbms_tts.transport_set_check('HISTO_DOSSIER_P1_MD_TAB',FALSE);
SQL
select * from sys.transport_set_violations;
VIOLATIONS
Partitioned
table TOPASE.HISTO_DOSSIER is partially contained in the transportab
le
set: check table partitions by querying sys.dba_tab_partitions
Default Partition (Table) Tablespace
HISTO_DOSSIER_P2_MD_TAB for HISTO_DOSSIER n
ot
contained in transportable set
Default Partition (Table) Tablespace
HISTO_DOSSIER_P3_MD_TAB for HISTO_DOSSIER n
ot
contained in transportable set
Default Partition (Table) Tablespace
HISTO_DOSSIER_P4_MD_TAB for HISTO_DOSSIER n
ot
contained in transportable set
