Re: imp/exp question
Hi, what do you mean with "to export in system user with two user tables" ? Regards, Adrian Ciocildau Oracle wrote: Dear One of the solution is you can export in system user with two user tables. You can exp/ imp blob column also. Later you can imp thru system, but use from user and to user options. I think it will help u. Thanks and Regards V.Baskaran -Original Message- Ciocildau Sent: Tuesday, October 29, 2002 11:18 To: Multiple recipients of list ORACLE-L Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau 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: imp/exp question
Adrian Ciocildau wrote: > > Hello, > > I have a problem and I hope you can help me. > > We have a Oracle 9 installation two users with two different default > tablespaces. The problem is to move data between theese two users with > imp/exp. > > I'll try to explain it a little bit more. > > we have userA with the default tablescape tabA and userB with tablB. > > first we want to do something like: > > exp userA/passA owner=(userA) file=dump.dmp > > and after: > > imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp > > If we do not have BLOB columns everything works fine. I think the > problem resides in the fact that in the case of a BLOB column the > STORAGE clause specifies in which tablespace the BLOB column > should be stored and this is not handled by the imp program (not > relocated in the tablespace B). > > I'm sure there should be a way to handle this but I was not able > to find it. > > Please help. > > Adrian > Adrian, what imp tries to do is recreate the object in the same tablespace as it originates from, and if this fails (because the tablespace doesn't exist or the target schema is not allowed to create segments in it) then it falls back on the default tablespace. Check that your target user HAS NOT the UNLIMITED TABLESPACE privilege, and play on quotas (setting them, even temporarily, to 0, when you do not want something to land somewhere) to direct segment creation where you want it to happen. It would be easy if you only had tables, but the presence of indexes, partitions or LOBs as in your case makes it a little difficult to play with when you want to totally relocate everything. It may be simpler to reimport under a different user but in the same tablespaces and then MOVE objects. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: imp/exp question
Dear One of the solution is you can export in system user with two user tables. You can exp/ imp blob column also. Later you can imp thru system, but use from user and to user options. I think it will help u. Thanks and Regards V.Baskaran -Original Message- Ciocildau Sent: Tuesday, October 29, 2002 11:18 To: Multiple recipients of list ORACLE-L Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau 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.com -- Author: Oracle 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).
imp/exp question
Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA and userB with tablB. first we want to do something like: exp userA/passA owner=(userA) file=dump.dmp and after: imp userB/passB fromuser=(userA) touser=(userB) file=dump.dmp If we do not have BLOB columns everything works fine. I think the problem resides in the fact that in the case of a BLOB column the STORAGE clause specifies in which tablespace the BLOB column should be stored and this is not handled by the imp program (not relocated in the tablespace B). I'm sure there should be a way to handle this but I was not able to find it. Please help. Adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Ciocildau 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).
