Imp of all users tables
List, How would I import all of one users tables (544) without listing all of them in the tables= option? I am using: imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y file=expdat.dmp How can I do all (and not a full=y) of the 544 tables for one user at one time? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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 of all users tables
-Original Message- imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y file=expdat.dmp How can I do all (and not a full=y) of the 544 tables for one user at one time? Leave out the tables=. Then it will default to all the tables of that user. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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-00098: Internal Error: impccr2
Hi all, I received quite interesting error during import. I am trying to put the dump from 8.1.6 database to 9i rel2 database on win2k server. The export dump was done with WE8ISO8859P1 character set and the target db is with UTF8 character set... Do you have any idea, or should I contact oracle support! Rgds, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
RE: full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user ifyou have toimport all indexes,constraints to a single tablespacethenfollowing procedurewillwork 4)After importing datachange the default tablespace to index tablespace ,ensure that no other ts quota(except index ts) is given to the schema .Grant sufficient quota on index tablespace . 5) do import with ignore=Y ,rows=no,indexes=y,constraints=y ,It will create indexes and constraints on index ts. 6) Revert back the default tablespace . Rajendra -Original Message-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure that user has a quota of ZERO on the TS from which the data was exported - otherwise the default import behavior will put the objects into the TS from which they were taken. Then just run the import (remembering, of course, to take all your small rollback segments offline and leave just one large rollback segment on line). If you want Indexes in a separate TS, then here's what I do: 1) set all as listed above, but make sure the user has unlimited quotas on both data and index TS 2) import data only - I use "constraints=n grants=n indexes=n" to insure it's only table data that gets in 3) import again with only the indexfile option, which will create a sql script 4) Edit the indexfile to remove stuff you don't want. . .I usemacros in my text editor to remove (in this order): ** all the lines beginning with "REM ...xRows imported" ** "REM CREATE TABLE " statements - start with that string and delete until the next semi-colon (end of the CREATE TABLE statement); these first two are for clarity only - so that I end up with a script that ONLY includes what I want, not all the other stuff, even though it's commented out. ** all remaining instances of the string "REM " (REM followed by two spaces) - this you must do to get all the ALTER TABLE statements properly. this leaves you with clean sql to just create constraints and indexes 5) do global search/replace for the index tablespace name (which is enclosed in double-quotes), putting in the name of the TS you want. 6) remove the line at the top that says "connect username" - you should connect first b4 running the script 7) save the file! 8) run the script to create all the indexes HTH bill -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
RE: full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user oh - I like that! thanks! -Original Message-From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]]Sent: Friday, November 08, 2002 2:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user ifyou have toimport all indexes,constraints to a single tablespacethenfollowing procedurewillwork 4)After importing datachange the default tablespace to index tablespace ,ensure that no other ts quota(except index ts) is given to the schema .Grant sufficient quota on index tablespace . 5) do import with ignore=Y ,rows=no,indexes=y,constraints=y ,It will create indexes and constraints on index ts. 6) Revert back the default tablespace . Rajendra -Original Message-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure that user has a quota of ZERO on the TS from which the data was exported - otherwise the default import behavior will put the objects into the TS from which they were taken. Then just run the import (remembering, of course, to take all your small rollback segments offline and leave just one large rollback segment on line). If you want Indexes in a separate TS, then here's what I do: 1) set all as listed above, but make sure the user has unlimited quotas on both data and index TS 2) import data only - I use "constraints=n grants=n indexes=n" to insure it's only table data that gets in 3) import again with only the indexfile option, which will create a sql script 4) Edit the indexfile to remove stuff you don't want. . .I usemacros in my text editor to remove (in this order): ** all the lines beginning with "REM ...xRows imported" ** "REM CREATE TABLE " statements - start with that string and delete until the next semi-colon (end of the CREATE TABLE statement); these first two are for clarity only - so that I end up with a script that ONLY includes what I want, not all the other stuff, even though it's commented out. ** all remaining instances of the string "REM " (REM followed by two spaces) - this you must do to get all the ALTER TABLE statements properly. this leaves you with clean sql to just create constraints and indexes 5) do global search/replace for the index tablespace name (which is enclosed in double-quotes), putting in the name of the TS you want. 6) remove the line at the top that says "connect username" - you should connect first b4 running the script 7) save the file! 8) run the script to create all the indexes HTH bill -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
RE: full exp/imp of user to new tablespace; same user
Title: RE: full exp/imp of user to new tablespace; same user A quick note to those that downloaded a version of DBATool yesterday following on from my message, and to all those that have a past version as well. The download link on the DBATool web page hadn't been updated for the new version that is on the web site - shoot the webmaster (me)! Following is a link to the latest version of DBATool (which has added support for partitioned table DDL etc.), if you would like to grab the latest download, just pull it down, and install straight over the version you already have.You do not need to de-install the old version, and will not have to re-apply for a registration key. http://www.cool-tools.co.uk/products/downloads/dbatool_install020306.exe Sorry for my stupidity! ;) Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Markham, RichardSent: 07 November 2002 16:14To: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user well now I can say I'm spoiled. I was given more than enough information to to accomplish the task (done) and a new tool to boot! =) Thanks alot everyone. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: full exp/imp of user to new tablespace; same user And if all else fails (not that the advice already given will!), we have a tool that can manipulate the DDL for the users objects VERY quickly and easily, through a "rule based" change (e.g. Modify ALL tables storage clauses within USERS schema to TABLESPACE): http://www.cool-tools.co.uk/products/dbatool.html It's free, have at it! HTH Mark -Original Message- Sent: 07 November 2002 14:44 To: Multiple recipients of list ORACLE-L Extra security could be to give zero quota on other tablespaces. -Original Message- Sent: donderdag 7 november 2002 14:59 To: Multiple recipients of list ORACLE-L I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user Choudhary out of curiousity, is itunderstood that you will need todrop the same recently imported indexes from the data TS before running the import into the index TS ? or will subsequent import cause a rebuild on the incoming indexes? -Original Message-From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]]Sent: Friday, November 08, 2002 2:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user ifyou have toimport all indexes,constraints to a single tablespacethenfollowing procedurewillwork 4)After importing datachange the default tablespace to index tablespace ,ensure that no other ts quota(except index ts) is given to the schema .Grant sufficient quota on index tablespace . 5) do import with ignore=Y ,rows=no,indexes=y,constraints=y ,It will create indexes and constraints on index ts. 6) Revert back the default tablespace . Rajendra -Original Message-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure that user has a quota of ZERO on the TS from which the data was exported - otherwise the default import behavior will put the objects into the TS from which they were taken. Then just run the import (remembering, of course, to take all your small rollback segments offline and leave just one large rollback segment on line). If you want Indexes in a separate TS, then here's what I do: 1) set all as listed above, but make sure the user has unlimited quotas on both data and index TS 2) import data only - I use "constraints=n grants=n indexes=n" to insure it's only table data that gets in 3) import again with only the indexfile option, which will create a sql script 4) Edit the indexfile to remove stuff you don't want. . .I usemacros in my text editor to remove (in this order): ** all the lines beginning with "REM ...xRows imported" ** "REM CREATE TABLE " statements - start with that string and delete until the next semi-colon (end of the CREATE TABLE statement); these first two are for clarity only - so that I end up with a script that ONLY includes what I want, not all the other stuff, even though it's commented out. ** all remaining instances of the string "REM " (REM followed by two spaces) - this you must do to get all the ALTER TABLE statements properly. this leaves you with clean sql to just create constraints and indexes 5) do global search/replace for the index tablespace name (which is enclosed in double-quotes), putting in the name of the TS you want. 6) remove the line at the top that says "connect username" - you should connect first b4 running the script 7) save the file! 8) run the script to create all the indexes HTH bill -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
Re: full exp/imp of user to new tablespace; same user
Markham, Richard wrote: I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. If all the objects are already stored in a single tablespace the simplest way is enough. Otherwise you are going to have a problem since everything will be created in the default tablespace (if there is enough space). INDEXFILE is not a perfect solution either because it 'forgets' indices associated with constraints (UNIQUE, PRIMARY KEY). The simplest way is, if you can afford it, to size generously your tablespace so that everything fits in. Then move all indices you want elsewhere out through ALTER INDEX ... REBUILD which is reasonably fast and also works on indices associated with constraints. It's easy to generate the query to do it by querying DBA_SEGMENTS. -- 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: full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure that user has a quota of ZERO on the TS from which the data was exported - otherwise the default import behavior will put the objects into the TS from which they were taken. Then just run the import (remembering, of course, to take all your small rollback segments offline and leave just one large rollback segment on line). If you want Indexes in a separate TS, then here's what I do: 1) set all as listed above, but make sure the user has unlimited quotas on both data and index TS 2) import data only - I use "constraints=n grants=n indexes=n" to insure it's only table data that gets in 3) import again with only the indexfile option, which will create a sql script 4) Edit the indexfile to remove stuff you don't want. . .I usemacros in my text editor to remove (in this order): ** all the lines beginning with "REM ...xRows imported" ** "REM CREATE TABLE " statements - start with that string and delete until the next semi-colon (end of the CREATE TABLE statement); these first two are for clarity only - so that I end up with a script that ONLY includes what I want, not all the other stuff, even though it's commented out. ** all remaining instances of the string "REM " (REM followed by two spaces) - this you must do to get all the ALTER TABLE statements properly. this leaves you with clean sql to just create constraints and indexes 5) do global search/replace for the index tablespace name (which is enclosed in double-quotes), putting in the name of the TS you want. 6) remove the line at the top that says "connect username" - you should connect first b4 running the script 7) save the file! 8) run the script to create all the indexes HTH bill -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
RE: full exp/imp of user to new tablespace; same user
-Original Message- I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. I have done many export/imports of user schemas without any problems in getting the entire schema. You shouldn't need to do anything special. To change the objects to a new tablespace: Drop the objects from the old tablespace; set the new tablespace to be the schema's default tablespace; set the schema's quota on the old tablespace(s) to be 0. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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: full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user Extra security could be to give zero quota on other tablespaces. -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: donderdag 7 november 2002 14:59To: Multiple recipients of list ORACLE-LSubject: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
RE: full exp/imp of user to new tablespace; same user
And if all else fails (not that the advice already given will!), we have a tool that can manipulate the DDL for the users objects VERY quickly and easily, through a rule based change (e.g. Modify ALL tables storage clauses within USERS schema to TABLESPACE): http://www.cool-tools.co.uk/products/dbatool.html It's free, have at it! HTH Mark -Original Message- Sent: 07 November 2002 14:44 To: Multiple recipients of list ORACLE-L Extra security could be to give zero quota on other tablespaces. -Original Message- Sent: donderdag 7 november 2002 14:59 To: Multiple recipients of list ORACLE-L I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: full exp/imp of user to new tablespace; same user
Title: RE: full exp/imp of user to new tablespace; same user well now I can say I'm spoiled. I was given more than enough information to to accomplish the task (done) and a new tool to boot! =) Thanks alot everyone. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: full exp/imp of user to new tablespace; same user And if all else fails (not that the advice already given will!), we have a tool that can manipulate the DDL for the users objects VERY quickly and easily, through a rule based change (e.g. Modify ALL tables storage clauses within USERS schema to TABLESPACE): http://www.cool-tools.co.uk/products/dbatool.html It's free, have at it! HTH Mark -Original Message- Sent: 07 November 2002 14:44 To: Multiple recipients of list ORACLE-L Extra security could be to give zero quota on other tablespaces. -Original Message- Sent: donderdag 7 november 2002 14:59 To: Multiple recipients of list ORACLE-L I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: full exp/imp of user to new tablespace; same user
Hi, is there anything else to do if moved tables have some indexes. Murat Stephen Lee [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: full exp/imp of user to new tablespace; same user 11/07/2002 05:14 PM Please respond to ORACLE-L -Original Message- I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. I have done many export/imports of user schemas without any problems in getting the entire schema. You shouldn't need to do anything special. To change the objects to a new tablespace: Drop the objects from the old tablespace; set the new tablespace to be the schema's default tablespace; set the schema's quota on the old tablespace(s) to be 0. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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: MURAT BALKAS 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).
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).
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
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).
exp/imp bug - Note:199416.1
Has anybody put on the patch to resolve this. On Nt, looks like fixed in 8.1.7.4.5. However, searching on the bug 2410612 reveals two other corruption bugs that appear unresolved. Have people put this patch on or waiting for a complete resolution. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: [Q] imp/exp error on 9iR2?
The password may not be a problem here. In 9i, sys must connect 'as sysdba' or 'as sysoper'. So, use 'sys as sysdba' when prompted for username (without the single quotes). If you want to use a parfile, then specify userid='sys/password as sysdba'. Those single quotes are needed and notice where 'as sysdba' goes :) HTH, - Kirti -Original Message- Sent: Friday, September 27, 2002 7:43 PM To: Multiple recipients of list ORACLE-L It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL connect / as sysdba Connected. SQL alter user sys identified by change_on_install User altered. SQL On Fri, Sep 27, 2002 at 02:51:37PM -0800, dist cash wrote: I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: sys Password: change_on_install IMP-00058: ORACLE error 28009 encountered ORA-28009: connection to sys should be as sysdba or sysoperUsername: Password: IMP-00058: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon deniedUsername: Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Deshpande, Kirti 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).
[Q] imp/exp error on 9iR2?
I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: sys Password: change_on_install IMP-00058: ORACLE error 28009 encountered ORA-28009: connection to sys should be as sysdba or sysoperUsername: Password: IMP-00058: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon deniedUsername: Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: [Q] imp/exp error on 9iR2?
It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL connect / as sysdba Connected. SQL alter user sys identified by change_on_install User altered. SQL On Fri, Sep 27, 2002 at 02:51:37PM -0800, dist cash wrote: I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: sys Password: change_on_install IMP-00058: ORACLE error 28009 encountered ORA-28009: connection to sys should be as sysdba or sysoperUsername: Password: IMP-00058: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon deniedUsername: Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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 need some help on imp
Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] 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: [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: Please need some help on imp
Bill, I assume from the way you state this, you already have the tables built and don't want imp to blow up trying to recreate them. Correct? If so, try ignore=y. Also, if the user is changing, are you using fromuser= touser=? Output from your problem might be helpful. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] 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: [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: John Weatherman INET: [EMAIL PROTECTED] 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: [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: Please need some help on imp
Bill Ignore=Y is that what you're looking for? Mike -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] 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: [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: Hand, Michael T INET: [EMAIL PROTECTED] 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: [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: Please need some help on imp
I assume that the schemas, tables, synonyms, roles, grants, etc already exist and you just want to populate the tables with the data from your other database. In your parm file set IGNORE=Y. This will ignore errors caused by already created objects and just load the data. Type: imp help=y to see all the parameters. HTH Bill Conner bill.conner To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @clarent.comcc: Sent by: rootSubject: Please need some help on imp 08/30/2002 03:44 PM Please respond to ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] 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: [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: Thomas Day INET: [EMAIL PROTECTED] 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: [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: Please need some help on imp
Bill, Where are you trying to load the data to? Do the tables already exist? If so, then use the ignore=y option and it won't complain if the table already exists when it tries to create it, but it will load the data into it. Bill Conner wrote: Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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 Problem
Hamid, Export your table with the INDEXES=N option, Drop the indexes from the target table ,Clean up the original table if it to be completely overwritten. Import the data. You could also insert into the original table with a select from the source table across a database link. 6 M rows took aprox 20 min across a dblink as compaired to hours with an exp/imp combination. ROR mª¿ªm [EMAIL PROTECTED] 07/18/02 01:55PM Dennis, I allow IMP to create it. -Original Message- Sent: Thursday, July 18, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hamid Did you pre-create the table on your target database, or are you allowing imp to create it? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Dear List, I am trying to import a table from another database which has partitioning, so after got few errors regarding the specific tablespace when I create the same tablespace it start loading data but after few thousand records stop with ORA-00018, my question is if we have a table which partitioned can we export it without partitioning info, so I could import it in my default tablespace, second question is how can I continue to import this sort of table completely. Now i have just part of table loaded . Thanks for your help. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender imme diately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
IMP/EXP Problem
Dear List, I am trying to import a table from another database which has partitioning, so after got few errors regarding the specific tablespace when I create the same tablespace it start loading data but after few thousand records stop with ORA-00018, my question is if we have a table which partitioned can we export it without partitioning info, so I could import it in my default tablespace, second question is how can I continue to import this sort of table completely. Now i have just part of table loaded . Thanks for your help. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [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 Problem
Hamid Did you pre-create the table on your target database, or are you allowing imp to create it? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Dear List, I am trying to import a table from another database which has partitioning, so after got few errors regarding the specific tablespace when I create the same tablespace it start loading data but after few thousand records stop with ORA-00018, my question is if we have a table which partitioned can we export it without partitioning info, so I could import it in my default tablespace, second question is how can I continue to import this sort of table completely. Now i have just part of table loaded . Thanks for your help. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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 Problem
Dennis, I allow IMP to create it. -Original Message- Sent: Thursday, July 18, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hamid Did you pre-create the table on your target database, or are you allowing imp to create it? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Dear List, I am trying to import a table from another database which has partitioning, so after got few errors regarding the specific tablespace when I create the same tablespace it start loading data but after few thousand records stop with ORA-00018, my question is if we have a table which partitioned can we export it without partitioning info, so I could import it in my default tablespace, second question is how can I continue to import this sort of table completely. Now i have just part of table loaded . Thanks for your help. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] 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: [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: Exp Imp User ?
utilities guide, happy reading. guess who wrote: I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] 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: [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).
Exp Imp User ?
I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] 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: [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: Exp Imp User ?
RTFM Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 18 Jun 2002 20:33:20 -0800 I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] 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: [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). Murali Vallath Oracle Certified DBA http://www8.ewebcity.com/muralivallath/ http://www.summerksyus.com/ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] 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: [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: Exp Imp User ?
All your questions are clearly answered in the Oracle Utilities Guide. Available (Free) at http://tahiti.oracle.com/pls/db92/db92.homepage?remark=tahiti. Try it. - Kirti -Original Message- Sent: Tuesday, June 18, 2002 11:33 PM To: Multiple recipients of list ORACLE-L I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] 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: [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: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [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: Exp Imp User ?
RTFM http://tahiti.oracle.com -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. guess who [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 19-06-2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Exp Imp User ? I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] 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: [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). STG10979 Description: Binary data
RE: Exp Imp User ?
This will get you started. http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?remark=word=Create+use rbook=a85397preference= http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch01.htm#17082 http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76955/ch02.htm RC -Original Message- From: guess who [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 June 2002 14:33 To: Multiple recipients of list ORACLE-L Subject: Exp Imp User ? I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the new user i have created. i want to know all the steps clearly for the above task... Kindly Help Regards, [EMAIL PROTECTED] _ Click below to visit monsterindia.com and there is always a better job for you at http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: guess who INET: [EMAIL PROTECTED] 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: [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: Ross Collado INET: [EMAIL PROTECTED] 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: [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: Exp/Imp Errors: Tablespace Specific?
Hi, I have One db instance containing three schemas to represent development, stage, and demo environments. I occassionally need to *roll* the schemas as a release occurs. We have been using import/export to accomplish this. In the past, another dba has done this task (so this is why I ask the question now). Schema1 (dev) Schema2 (stage) Schema3 (demo) In order to roll out I did the following (after backing up all three of course:): 1) Create export file of schema1 2) Create export file of schema2 3) Drop all schema objects in Schema2 4) Drop all schema objects in Schema3 5) Import Schema1 dmp file into Schema2 6) Import Schema2 dmp file into Schema3 Everything went fine except for step 5. I received errors on ALL of the PK constraints : . . importing table ACCOUNT 17972 rows imported IMP-00015: following statement failed because the object already exists: ALTER TABLE ACCOUNT ADD CONSTRAINT PK_ACCOUNT PRIMARY KEY (ACCOUNT_ID ,GENERATION) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT IAL 8388608) TABLESPACE AURDEV_TS ENABLE Also, had it added one trigger twice (may NOT be a related issue) - I deleted the extra trigger and recompiled it and it was fine (but it was weird to see two with same name). Also, received errors on ALL of the FKs (as the referencing PKs did not exist). IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE COMMODITY ADD CONSTRAINT FK_COMMODITY_SECURITY FOREIGN KEY (SECURITY_ID,GENERATION) REFERENCES SECURITY (SECURITY_ID,GENERATI ON) ENABLE NOVALIDATE Then, err'd out on enabling all constraints (Of course.) My main question is why does it think that the object already exists? I imported using FromUser Touser. The only thing I can see is that the error also is containing the tablespace that is assigned to Schema1. Schema2 and Schema3 use the same tablespace which differs from the tablespace assigned to Schema1. ie: SchemaDefault Tablespace *** Schema1tablespace1 Schema2tablespace2 Schema3tablespace2 I am wondering if the error is inaccurate and what the error should read is that the current user is not assigned as a resource to the named tablespace. So, I am wondering how to strip the tablespace specification out of the import. Actually I am not understanding why it is there at all as I dont believe that the storage info should be there? Any clues? Thanks, Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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).
Exp/Imp Errors: Tablespace Specific?
Hi,
I
have One db instance containing three schemas to represent development, stage,
and demo environments. I occassionally need to *roll* the schemas as a
release occurs.
We have been using import/export to accomplish this. In the past, another
dba has done this task (so this is why I ask the question
now).
Schema1 (dev)
Schema2 (stage)
Schema3 (demo)
In order to roll out I did the following (after backing up all three of
course:):
1) Create exportfile of
schema1
2) Create export file of schema2
3) Drop all schema objects in Schema2
4) Drop all schema objects in Schema3
5) Import Schema1 dmp file into Schema2
6) Import Schema2 dmp file into Schema3
Everything went fine
except for step 5. I received errors on ALL of the PK constraints
:
. . importing
table
"ACCOUNT" 17972 rows importedIMP-00015:
following statement failed because the object already exists:"ALTER
TABLE "ACCOUNT" ADD CONSTRAINT "PK_ACCOUNT" PRIMARY KEY
("ACCOUNT_ID""","GENERATION") USING INDEX PCTFREE 10 INITRANS 2
MAXTRANS 255 STORAGE(INIT""IAL 8388608) TABLESPACE "AURDEV_TS" ENABLE
"
Also, had it added
one trigger twice (may NOT be a related issue) - I deleted the extra trigger and
recompiled it and it was fine (but it was weird to see two with same
name).
Also, received
errors on ALL of the FKs (as the referencing PKs did not
exist).
IMP-3: ORACLE
error 2270 encounteredORA-02270: no matching unique or primary key for this
column-listIMP-00017: following statement failed with ORACLE error
2270:"ALTER TABLE "COMMODITY" ADD CONSTRAINT "FK_COMMODITY_SECURITY"
FOREIGN KEY ""("SECURITY_ID","GENERATION") REFERENCES "SECURITY"
("SECURITY_ID","GENERATI""ON") ENABLE NOVALIDATE"
Then, err'd out on
enabling all constraints (Of course.)
My main question is
why does it think that the object already exists? I imported using
FromUser Touser. The only thing I can see is that the error also is
containing the tablespace that is assigned to Schema1. Schema2 and Schema3
use the same tablespace which differs from the tablespace assigned to Schema1.
ie:
Schema Default
Tablespace
**
*
Schema1
tablespace1
Schema2
tablespace2
Schema3
tablespace2
I am wondering if
the error is inaccurate and what the error should read is that the current user
is not assigned as a resource to the named tablespace. So, I am
wondering how to strip the tablespace specification out of the import.
Actually I am not
understanding why it is there at all as I dont believe that the storage info
should be there?
Any
clues?
Thanks,
Hannah
exp/imp question
List, Source database 7.3.4 OS Novell 4.2 Target database 8.1.7 OS Linux RedHat 7.2 Table is 5 columns ,indexes on columns 1,2PK, 1,3 , 3 for application usage Export of a table is 750K rows and takes about 2 minutes with a DMP file the size of 20 Meg. Import command in the V$SQLAREA shows INSERT /*NESTED_TABLE_SET_REFS*/ INTO DRITV (COL1,COL2,COL3,COL4,COL5) VALUES(:1,:2,:3,:4,:5) and takes 1.5+ hours. The table is truncated because this is a copy of data from production to a test database. Question is why could it be taking such a long time to load and I have not been able to find the hint info in my of my doc's. The table is not a nested table and the hint confuses me. What does it mean. I am going to truncate the table again and do a copy across the network to get the time for that action. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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: exp/imp question
I would take a look at v$session_wait whilst the import is running and see what pops up. My understanding of NESTED_TABLE_SET_REFS is to get at the hidden columns when object data types are used. I'm not sure why it always seems to be so prevalent in import - possibly they just do it with any old table and the hint is ignored except in the object case hth connor --- Ron Rogers [EMAIL PROTECTED] wrote: List, Source database 7.3.4 OS Novell 4.2 Target database 8.1.7 OS Linux RedHat 7.2 Table is 5 columns ,indexes on columns 1,2PK, 1,3 , 3 for application usage Export of a table is 750K rows and takes about 2 minutes with a DMP file the size of 20 Meg. Import command in the V$SQLAREA shows INSERT /*NESTED_TABLE_SET_REFS*/ INTO DRITV (COL1,COL2,COL3,COL4,COL5) VALUES(:1,:2,:3,:4,:5) and takes 1.5+ hours. The table is truncated because this is a copy of data from production to a test database. Question is why could it be taking such a long time to load and I have not been able to find the hint info in my of my doc's. The table is not a nested table and the hint confuses me. What does it mean. I am going to truncate the table again and do a copy across the network to get the time for that action. Thanks, Ron ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [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: Trouble with imp on 8.1.6
What does your imp command look like? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Trouble with imp on 8.1.6 om 01/18/2002 09:00 AM Please respond to ORACLE-L Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following message but no tables are created? I have full privs. Can someone help? Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) Import terminated successfully without warnings. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: INET: [EMAIL PROTECTED] 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: [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: Trouble with imp on 8.1.6
HI Rick, Could you share with us the export statement and the import statement you used. Tha will help figure out what went wrong. John [EMAIL PROTECTED] wrote: Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following message but no tables are created? I have full privs. Can someone help? Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) Import terminated successfully without warnings. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] 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: [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: Trouble with imp on 8.1.6
Rick, By default Oracle will import from/to the same user only. You can do what you want by using the fromuser/touser option. Something like imp user/pwd file=x.dmp fromuser=from touser=to Type imp help=y for the specifics. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 18, 2002 10:01 AM To: Multiple recipients of list ORACLE-L Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following message but no tables are created? I have full privs. Can someone help? Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) Import terminated successfully without warnings. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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: Trouble with imp on 8.1.6
imp user/pass@service file=file.dmp log=test.log fromuser=caler touser=newuser tables=(*) I have also done above with charset=us7ascii no difference Rick [EMAIL PROTECTED] .tenet.edu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Trouble with imp on 8.1.6 01/18/2002 11:10 AM Please respond to ORACLE-L What does your imp command look like? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Trouble with imp on 8.1.6 om 01/18/2002 09:00 AM Please respond to ORACLE-L Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following message but no tables are created? I have full privs. Can someone help? Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) Import terminated successfully without warnings. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: INET: [EMAIL PROTECTED] 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: [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: INET: [EMAIL PROTECTED] 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: [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: Trouble with imp on 8.1.6
exp system/pass@service file=file.dmp log=exp.log user=(adtlite) The exp.log shows all objects exported correctly. imp system/pass@service file=file.dmp log=test.log fromuser=system touser=caler tables=(*) Rick orantdba orantdba@netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scape.net cc: Sent by: Subject: Re: Trouble with imp on 8.1.6 root@fatcity. com 01/18/2002 11:50 AM Please respond to ORACLE-L HI Rick, Could you share with us the export statement and the import statement you used. Tha will help figure out what went wrong. John [EMAIL PROTECTED] wrote: Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following message but no tables are created? I have full privs. Can someone help? Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) Import terminated successfully without warnings. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] 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: [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: INET: [EMAIL PROTECTED] 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: [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 b/w 8.1.7 and 8.1.6
Hi list, I have 2 db instances on two different boxes; one is 8.1.7.0.0 and the second one 8.1.6.0.0, if I want to import data from 8.1.7.0.0 into 8.1.6.0.0 database, what should I do, The first solution which comes into my mind is to use 8.1.6's "exp" command to export data from 8.1.7 and then "imp" to import in it. But will that work? Or I have to set some COMPATIBLE parameter on 8.1.7/8.1.6 init file?? Thanks in advance Arslan Zaheer Dar
Exp / Imp Utility Questions
I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old tables / data to the new application on my conversion server. Now I have to load it onto a test server at a different site. I will be using tables= parameter to a select group of tables / data. I have not found the answers to my questions in the documentation. 1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures? 2. The conversion DB that I have only has the tables, PK's, FK's, and indexes and no triggers, functions, cursors, etc. (they are created by another script). There is no application code attached to this DB. The DB I will be loading to is fully functional - all the PK's, FK's, triggers, functions, et al. Will loading the data from my conversion DB cause problems with the test DB? 3. I know I will have to disable the FK's on the test DB. But, what about the triggers on the applicable tables? Should they be disabled? Anything else I need to know before I get rolling on this? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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: Exp / Imp Utility Questions
Title: RE: Exp / Imp Utility Questions 1) You cannot have read the docs to well not to know the answer to Q1 Hint - look at the ignore parameter to imp 2) It all depends if the triggers have been run once to change the data that is now in the conversion db. You may have a trigger that adds 1 to a field. If the data has been populated into a table with the trigger enabled it will have value of field + 1. If you then import the data into your test db with a trigger enabled it will action the trigger and the field will then have the value of field +1 +1. Remember import is only a fancy way of typing insert into for each row of data 3) As you say, it is a test database, experiment with a couple of tables and find out the answers for yourself. That is the best way of learning John -Original Message- From: Ken Janusz [mailto:[EMAIL PROTECTED]] Sent: 28 December 2001 12:45 To: Multiple recipients of list ORACLE-L Subject: Exp / Imp Utility Questions I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old tables / data to the new application on my conversion server. Now I have to load it onto a test server at a different site. I will be using tables= parameter to a select group of tables / data. I have not found the answers to my questions in the documentation. 1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures? 2. The conversion DB that I have only has the tables, PK's, FK's, and indexes and no triggers, functions, cursors, etc. (they are created by another script). There is no application code attached to this DB. The DB I will be loading to is fully functional - all the PK's, FK's, triggers, functions, et al. Will loading the data from my conversion DB cause problems with the test DB? 3. I know I will have to disable the FK's on the test DB. But, what about the triggers on the applicable tables? Should they be disabled? Anything else I need to know before I get rolling on this? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
Re: Exp / Imp Utility Questions
Ken Janusz wrote: I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old tables / data to the new application on my conversion server. Now I have to load it onto a test server at a different site. I will be using tables= parameter to a select group of tables / data. I have not found the answers to my questions in the documentation. 1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures? If you do not specify IGNORE=Y, if the table already exists (which I presume is the case since you only are interested by the data) the default behaviour is to skip the data. So, the answer is yes if you specify IGNORE=Y. 2. The conversion DB that I have only has the tables, PK's, FK's, and indexes and no triggers, functions, cursors, etc. (they are created by another script). There is no application code attached to this DB. The DB I will be loading to is fully functional - all the PK's, FK's, triggers, functions, et al. Will loading the data from my conversion DB cause problems with the test DB? No. 3. I know I will have to disable the FK's on the test DB. But, what about the triggers on the applicable tables? Should they be disabled? Yes, because imp fires them if they preexist. Anything else I need to know before I get rolling on this? You will probably get lots of error messages in the process ... You may find this useful : http://www.oriole.com/frameindexFS.html and check for the 'All you ever wanted to know about exp and imp' paper. HTH, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [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: Exp / Imp Utility Questions
You can use imp to move just the data. Just set ignore=y so that when the object already exists it will move on. You are right about the FK's and disabling them. As for triggers, it really depends on whether or not you want them to fire... -Original Message- Sent: Friday, December 28, 2001 4:45 AM To: Multiple recipients of list ORACLE-L I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old tables / data to the new application on my conversion server. Now I have to load it onto a test server at a different site. I will be using tables= parameter to a select group of tables / data. I have not found the answers to my questions in the documentation. 1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures? 2. The conversion DB that I have only has the tables, PK's, FK's, and indexes and no triggers, functions, cursors, etc. (they are created by another script). There is no application code attached to this DB. The DB I will be loading to is fully functional - all the PK's, FK's, triggers, functions, et al. Will loading the data from my conversion DB cause problems with the test DB? 3. I know I will have to disable the FK's on the test DB. But, what about the triggers on the applicable tables? Should they be disabled? Anything else I need to know before I get rolling on this? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [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).
Exp/Imp Utility
If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am importing to, will Imp generate an error? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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: Exp/Imp Utility
Hell yes! Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 20, 2001 12:46 PM To: Multiple recipients of list ORACLE-L If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am importing to, will Imp generate an error? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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: Sherman, Paul R. INET: [EMAIL PROTECTED] 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: [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: Exp/Imp Utility
It sure will. --- Ken Janusz [EMAIL PROTECTED] wrote: If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am importing to, will Imp generate an error? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] 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: [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: Exp/Imp Utility
read the fine manuals you cannot import into a table that has a different definition of columns. --- Ken Janusz [EMAIL PROTECTED] wrote: If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am importing to, will Imp generate an error? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] 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: [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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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).
Weid exp/imp problem
Title: Weid exp/imp problem Hi! I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical. What I do is this: - export user (using exp) from development. Works flawlessly. - import user into the other box (user setup and tablespaces are identical) An I get the following errors which doesn't make a lot of sense to me... ... . . importing table TABELLEN 37 rows imported . . importing table TABELLEN_ZUORDNUNGEN 28 rows imported . . importing table TMP$TEST 1 rows imported . . importing table TMP_FUNKTIONS_PARAMETER 0 rows imported . . importing table TMP_FUNKTIONS_SPALTEN 0 rows imported . . importing table USEREXIT 5 rows imported . . importing table USEREXIT_TYPE 3 rows imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK FOREIGN KEY (BNGR_ID) REFERENCES BENUTZER_GRUPPEN (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_OW_FK FOREIGN K EY (OW_ID) REFERENCES OWNER (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list ... Any ideas why this is happening? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Re: Weid exp/imp problem
Hi You are most likely importing a table with foreign key prior to importing the primary key that it points to. you can do export with constraints N (I think) . Recreate the constraints after import. Or export your tables in the right order so the primary keys get imported first (use a parfile) Jack Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 19-12-2001 09:25:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical. What I do is this: - export user (using exp) from development. Works flawlessly. - import user into the other box (user setup and tablespaces are identical) An I get the following errors which doesn't make a lot of sense to me... ... . . importing table TABELLEN 37 rows imported . . importing table TABELLEN_ZUORDNUNGEN 28 rows imported . . importing table TMP$TEST 1 rows imported . . importing table TMP_FUNKTIONS_PARAMETER 0 rows imported . . importing tableTMP_FUNKTIONS_SPALTEN 0 rows imported . . importing table USEREXIT 5 rows imported . . importing tableUSEREXIT_TYPE 3 rows imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK FOREIGN KEY (BNGR_ID) REFERENCES BENUTZER_GRUPPEN (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_OW_FK FOREIGN K EY (OW_ID) REFERENCES OWNER (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list ... Any ideas why this is happening? This is 8.1.7 on Sun Solaris. Thanks, Helmut === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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: Weid exp/imp problem
[EMAIL PROTECTED] wrote: Hi You are most likely importing a table with foreign key prior to importing the primary key that it points to. you can do export with constraints N (I think) . Recreate the constraints after import. Or export your tables in the right order so the primary keys get imported first (use a parfile) Jack Normally, the export dumps table CREATE statements, data, CREATE INDEX, CHECK, UNIQUE and PRIMARY KEY constraints, and foreign keys come at the very end, after ALL tables. It looks indeed like some primary keys were not defined on the target box in the first place. Helmut, you should take a look to DBA_CONSTRAINTS. Daiminger, Helmut [EMAIL PROTECTED]@fatcity.com on 19-12-2001 09:25:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hi! I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical. What I do is this: - export user (using exp) from development. Works flawlessly. - import user into the other box (user setup and tablespaces are identical) An I get the following errors which doesn't make a lot of sense to me... ... . . importing table TABELLEN 37 rows imported . . importing table TABELLEN_ZUORDNUNGEN 28 rows imported . . importing table TMP$TEST 1 rows imported . . importing table TMP_FUNKTIONS_PARAMETER 0 rows imported . . importing tableTMP_FUNKTIONS_SPALTEN 0 rows imported . . importing table USEREXIT 5 rows imported . . importing tableUSEREXIT_TYPE 3 rows imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK FOREIGN KEY (BNGR_ID) REFERENCES BENUTZER_GRUPPEN (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_OW_FK FOREIGN K EY (OW_ID) REFERENCES OWNER (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list ... Any ideas why this is happening? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [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: Weid exp/imp problem
Title: Weid exp/imp problem
This
error is coming because at the time of adding foreign key constraint ,
referencing primary key is not available.
You
can avoid this error by creating a similar schema in the user in which you are
taking the import and then import data
with
parameter "ignore=Y".
Kranti
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December
19, 2001 1:55 PMTo: Multiple recipients of list
ORACLE-LSubject: Weid exp/imp problem
Hi!
I'm experiencing a weird problem here... I'm about to move one
user's object from the development box to a test box. The user's rights on
both boxes are identical.
What I do is this: - export user
(using exp) from development. Works flawlessly. -
import user into the other box (user setup and tablespaces are
identical)
An I get the following errors which doesn't make a lot of
sense to me... ... . .
importing
table
"TABELLEN" 37 rows
imported . . importing
table
"TABELLEN_ZUORDNUNGEN" 28 rows
imported . . importing
table
"TMP$TEST" 1 rows
imported . . importing
table
"TMP_FUNKTIONS_PARAMETER"
0 rows imported . . importing
table
"TMP_FUNKTIONS_SPALTEN"
0 rows imported . . importing
table
"USEREXIT" 5 rows
imported . . importing
table
"USEREXIT_TYPE" 3 rows
imported . . importing
table
"ZYKLUS" 7 rows
imported IMP-00017: following statement failed with
ORACLE error 2270: "ALTER TABLE
"BENUTZER_GRUPPEN_ZUORD" ADD CONSTRAINT "BNGRZ_BNGR_FK" FOREIGN"
" KEY ("BNGR_ID") REFERENCES "BENUTZER_GRUPPEN" ("ID")
ENABLE NOVALIDATE" IMP-3: ORACLE error 2270
encountered ORA-02270: no matching unique or primary
key for this column-list IMP-00017: following
statement failed with ORACLE error 2270: "ALTER
TABLE "BENUTZER_GRUPPEN_ZUORD" ADD CONSTRAINT "BNGRZ_OW_FK" FOREIGN K"
"EY ("OW_ID") REFERENCES "OWNER" ("ID") ENABLE
NOVALIDATE" IMP-3: ORACLE error 2270
encountered ORA-02270: no matching unique or primary
key for this column-list ...
Any ideas why this is happening?
This is 8.1.7 on Sun Solaris.
Thanks, Helmut
RE: Weid exp/imp problem
You can handle this by two ways. The first is running the imp in two times. And the second imp with rows=n and ignore=y. On the other hand, you can create all the objects with the constraints INITIALLY DEFERRED. With the precaution that you can not undo the mode of the constraint with an alter table command. Therefore, you could do it with INITIALLY IMMEDIATE the default mode, but it would hurt the performance of the import. To get the stmts of creation, you can run the imp with show=y and get all the stmts or if you have 9i you could use DBMS_METADATA package. Regards. --- kranti pushkarna [EMAIL PROTECTED] wrote: This error is coming because at the time of adding foreign key constraint , referencing primary key is not available. You can avoid this error by creating a similar schema in the user in which you are taking the import and then import data with parameter ignore=Y. Kranti -Original Message- Sent: Wednesday, December 19, 2001 1:55 PM To: Multiple recipients of list ORACLE-L Hi! I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical. What I do is this: - export user (using exp) from development. Works flawlessly. - import user into the other box (user setup and tablespaces are identical) An I get the following errors which doesn't make a lot of sense to me... ... . . importing table TABELLEN 37 rows imported . . importing table TABELLEN_ZUORDNUNGEN 28 rows imported . . importing table TMP$TEST 1 rows imported . . importing table TMP_FUNKTIONS_PARAMETER 0 rows imported . . importing tableTMP_FUNKTIONS_SPALTEN 0 rows imported . . importing table USEREXIT 5 rows imported . . importing tableUSEREXIT_TYPE 3 rows imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK FOREIGN KEY (BNGR_ID) REFERENCES BENUTZER_GRUPPEN (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_OW_FK FOREIGN K EY (OW_ID) REFERENCES OWNER (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list ... Any ideas why this is happening? This is 8.1.7 on Sun Solaris. Thanks, Helmut = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [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: Weid exp/imp problem
Title: Weid exp/imp problem Helmut: This could be due to the fact that constraints on those tables have not been defined yet. Since tables are imported in Alpha order, I would suggest performing a no-data import after this one is complete. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:25 AM To: Multiple recipients of list ORACLE-L Subject: Weid exp/imp problem Hi! I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical. What I do is this: - export user (using exp) from development. Works flawlessly. - import user into the other box (user setup and tablespaces are identical) An I get the following errors which doesn't make a lot of sense to me... ... . . importing table TABELLEN 37 rows imported . . importing table TABELLEN_ZUORDNUNGEN 28 rows imported . . importing table TMP$TEST 1 rows imported . . importing table TMP_FUNKTIONS_PARAMETER 0 rows imported . . importing table TMP_FUNKTIONS_SPALTEN 0 rows imported . . importing table USEREXIT 5 rows imported . . importing table USEREXIT_TYPE 3 rows imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK FOREIGN KEY (BNGR_ID) REFERENCES BENUTZER_GRUPPEN (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_OW_FK FOREIGN K EY (OW_ID) REFERENCES OWNER (ID) ENABLE NOVALIDATE IMP-3: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list ... Any ideas why this is happening? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: Weid exp/imp problem
Title: Weid exp/imp problem
You
may need to use consistent=y on the export to ensure that the view for the
entire export run is from one snapshot in time. If your application is
busy changing data during the export, then as export moves through the list of
tables (alphabetically I think) then you'll get some tables at the beginning of
the list from one time, and tables late in the list from another with possible
referential problems just as exhibited below.
hope
this helps,
Steve
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December
19, 2001 2:25 AMTo: Multiple recipients of list
ORACLE-LSubject: Weid exp/imp problem
Hi!
I'm experiencing a weird problem here... I'm about to move one
user's object from the development box to a test box. The user's rights on
both boxes are identical.
What I do is this: - export user
(using exp) from development. Works flawlessly. -
import user into the other box (user setup and tablespaces are
identical)
An I get the following errors which doesn't make a lot of
sense to me... ... . .
importing
table
"TABELLEN" 37 rows
imported . . importing
table
"TABELLEN_ZUORDNUNGEN" 28 rows
imported . . importing
table
"TMP$TEST" 1 rows
imported . . importing
table
"TMP_FUNKTIONS_PARAMETER"
0 rows imported . . importing
table
"TMP_FUNKTIONS_SPALTEN"
0 rows imported . . importing
table
"USEREXIT" 5 rows
imported . . importing
table
"USEREXIT_TYPE" 3 rows
imported . . importing
table
"ZYKLUS" 7 rows
imported IMP-00017: following statement failed with
ORACLE error 2270: "ALTER TABLE
"BENUTZER_GRUPPEN_ZUORD" ADD CONSTRAINT "BNGRZ_BNGR_FK" FOREIGN"
" KEY ("BNGR_ID") REFERENCES "BENUTZER_GRUPPEN" ("ID")
ENABLE NOVALIDATE" IMP-3: ORACLE error 2270
encountered ORA-02270: no matching unique or primary
key for this column-list IMP-00017: following
statement failed with ORACLE error 2270: "ALTER
TABLE "BENUTZER_GRUPPEN_ZUORD" ADD CONSTRAINT "BNGRZ_OW_FK" FOREIGN K"
"EY ("OW_ID") REFERENCES "OWNER" ("ID") ENABLE
NOVALIDATE" IMP-3: ORACLE error 2270
encountered ORA-02270: no matching unique or primary
key for this column-list ...
Any ideas why this is happening?
This is 8.1.7 on Sun Solaris.
Thanks, Helmut
exp/imp unable to create unix index
Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported importing table PA_PROJECTS_ALL 3160 rows imported exporting tablePO_VENDORS 57688 rows exported importing table PO_VENDORS 57688 rows imported Why, any idea? Mitchell This is the log from imp. IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PA_PROJECTS_U3 ON PA_PROJECTS_ALL (NAME ) PCTFRE E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL D EFAULT) TABLESPACE PAX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PO_VENDORS_U2 ON PO_VENDORS (VENDOR_NAME ) PCTFR EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144 MINEXTENT S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE POX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] 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: [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).
AW: exp/imp unable to create unix index
Maybe the tables still exist in Prod and have some data inside. Try to drop tables in prod before importing. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: mitchell [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 18:40 An: Multiple recipients of list ORACLE-L Betreff: exp/imp unable to create unix index Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported importing table PA_PROJECTS_ALL 3160 rows imported exporting tablePO_VENDORS 57688 rows exported importing table PO_VENDORS 57688 rows imported Why, any idea? Mitchell This is the log from imp. IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PA_PROJECTS_U3 ON PA_PROJECTS_ALL (NAME ) PCTFRE E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL D EFAULT) TABLESPACE PAX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PO_VENDORS_U2 ON PO_VENDORS (VENDOR_NAME ) PCTFR EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144 MINEXTENT S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE POX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] 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: [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: Schoen Volker INET: [EMAIL PROTECTED] 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: [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: exp/imp unable to create unix index
Were the tables (Where you imported / PROD ) EMPTY ??? What is the version of ORACLE that you are using ?? Is this constraint ENABLED in TEST (From where you exported).. ?? Check.. chances are that it is disabled there.. HTH Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 09:40 AM Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported importing table PA_PROJECTS_ALL 3160 rows imported exporting tablePO_VENDORS 57688 rows exported importing table PO_VENDORS 57688 rows imported Why, any idea? Mitchell This is the log from imp. IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PA_PROJECTS_U3 ON PA_PROJECTS_ALL (NAME ) PCTFRE E 5 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 344064 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL D EFAULT) TABLESPACE PAX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found IMP-00017: following statement failed with ORACLE error 1452: CREATE UNIQUE INDEX PO_VENDORS_U2 ON PO_VENDORS (VENDOR_NAME ) PCTFR EE 0 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 3457024 NEXT 262144 MINEXTENT S 1 MAXEXTENTS 1024 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE POX NOLOGGING IMP-3: ORACLE error 1452 encountered ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] 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: [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: Nikunj Gupta INET: [EMAIL PROTECTED] 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: [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-00037 Character marker set unknown
Hi DBAs, I trying to import uncorrupted 8.0.5 export into a Oracle 9i database. I get a IMP-00037 Character marker set unknown. MetaLink says it may be corrupted. It is not so anyone have any other suggestions? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [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: invalid object after imp
Dear DBAs I exp/imp whole OFA database and there are some invalid package bodies left on newly imported db. When I recompile it I got message insufficient privilege to access object SYS.DBMS_LOCK I check dba_sys_priv and both exp and imp databases are the same for those package bodies owner. I also checked dbms_lock and found everybody has exec privilege on the package. What is wrong. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] 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: [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).
Full IMP hangs at the same spot
Title: Full IMP hangs at the same spot We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a full exp/imp into a clone database. The imp hangs at the same location every time, on a table that has only 2 rows in it, although the table does have 2 VARCHAR2(2000) columns. We're unable to locate any error messages in the available alerts, logs, traces, whatever. For whatever reason, the process just goes suddenly wild on CPU cycles and hangs there. Any ideas? Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
RE: Full IMP hangs at the same spot
Title: Full IMP hangs at the same spot truss, strace whatever. v$session_wait the usual -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, September 07, 2001 11:46 AMTo: Multiple recipients of list ORACLE-LSubject: Full IMP hangs at the same spot We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a full exp/imp into a clone database. The imp hangs at the same location every time, on a table that has only 2 rows in it, although the table does have 2 VARCHAR2(2000) columns. We're unable to locate any error messages in the available alerts, logs, traces, whatever. For whatever reason, the process just goes suddenly wild on CPU cycles and hangs there. Any ideas? Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
Re: Full IMP hangs at the same spot
Did you run out of room in the target database? Rutg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 07, 2001 11:45 AM We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a full exp/imp into a clone database. The imp hangs at the same location every time, on a table that has only 2 rows in it, although the table does have 2 VARCHAR2(2000) columns. We're unable to locate any error messages in the available alerts, logs, traces, whatever.For whatever reason, the process just goes suddenly wild on CPU cycles and hangs there. Any ideas? Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [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: Full IMP hangs at the same spot
Title: Message Any triggers? "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 11:46 AMTo: Multiple recipients of list ORACLE-LSubject: Full IMP hangs at the same spot We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a full exp/imp into a clone database. The imp hangs at the same location every time, on a table that has only 2 rows in it, although the table does have 2 VARCHAR2(2000) columns. We're unable to locate any error messages in the available alerts, logs, traces, whatever. For whatever reason, the process just goes suddenly wild on CPU cycles and hangs there. Any ideas? Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba
Solved: IMP-00069 error when importing 8.1.7 export
Hi list, I got the export made with exp V8.1.6 and succesfully imported it with imp V8.1.7 to oracle 8.1.5 database. A lot of versiosn to use. Thanks to all who replied Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Schoen Volker Gesendet: Montag, 3. September 2001 14:26 An: 'Oracle Lazy DBA list'; 'Oracle List (fatcity)' Betreff: IMP-00069 error when importing 8.1.7 export Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] 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: [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-00069 error when importing 8.1.7 export
Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] 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: [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-00069 error when importing 8.1.7 export
Hi, can you export your 81700 db with the 81701 exp utility? oli [EMAIL PROTECTED] wrote: Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] 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: [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). -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] 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: [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 8.1.6 to 8.1.7 DB
I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you
Re: IMP 8.1.6 to 8.1.7 DB
wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM Subject: IMP 8.1.6 to 8.1.7 DB I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you
Re: IMP 8.1.6 to 8.1.7 DB
Thank you Sharma, Lunch is in my mind :) - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 11:40 AM Subject: Re: IMP 8.1.6 to 8.1.7 DB wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM Subject: IMP 8.1.6 to 8.1.7 DB I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you
RE: IMP 8.1.6 to 8.1.7 DB
Yes you can, you haveto use the exp utility from 8.1.7 to export the db, then you use the exp from 8.1.7 to the 8.1.6. KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh SharmaSent: Wednesday, August 08, 2001 4:40 AMTo: Multiple recipients of list ORACLE-LSubject: Re: IMP 8.1.6 to 8.1.7 DB wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM Subject: IMP 8.1.6 to 8.1.7 DB I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you
RE: IMP 8.1.6 to 8.1.7 DB
I thought the question was taking an 816 .dmp files into 817. If that is the question, the answer is yes. You can usually/always go from older into newer. Its one of the 3 upgrade/migration methods - even in 9i. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Wed, 08 Aug 2001 06:16:09 Kevin Kostyszyn wrote: Yes you can, you have to use the exp utility from 8.1.7 to export the db, then you use the exp from 8.1.7 to the 8.1.6. KK -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh Sharma Sent: Wednesday, August 08, 2001 4:40 AM To: Multiple recipients of list ORACLE-L Subject: Re: IMP 8.1.6 to 8.1.7 DB wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM Subject: IMP 8.1.6 to 8.1.7 DB I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] 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: [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 use/pas file=blah.dmp log=blah.dmp...
Here is a fun one for you. If you set the log file to the dump file on you import it will of course wipe out your dump file. However, Oracle is nice enough to go ahead and tell you *after* it wipes out your dump file that setting your log file to your dump file is an invalid option! I converted a bunch of tablespaces to LMT this weekend and noticed that they required about 10% more space than the DD managed. I did not change any of the settings other than using UNIFORM extents of 128K for the most part. Some of the tablespaces had very few objects so the slack on small objects did not account for the increase %. I am sure this has been covered but a quick search of Usenet and metalink didn't give me anything. Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [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 use/pas file=blah.dmp log=blah.dmp...
Ethan, you wanted them to tell you BEFORE it wiped it out?, thats in oracle 10i :) joe [EMAIL PROTECTED] 07/30/01 01:00PM Here is a fun one for you. If you set the log file to the dump file on youimport it will of course wipe out your dump file. However, Oracle is niceenough to go ahead and tell you *after* it wipes out your dump file thatsetting your log file to your dump file is an invalid option!I converted a bunch of tablespaces to LMT this weekend and noticed that theyrequired about 10% more space than the DD managed. I did not change any ofthe settings other than using UNIFORM extents of 128K for the most part.Some of the tablespaces had very few objects so the slack on small objectsdid not account for the increase %. I am sure this has been covered but aquick search of Usenet and metalink didn't give me anything.Thanks,Ethan--This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.==-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Post, Ethan INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: imp use/pas file=blah.dmp log=blah.dmp...
Actually some version do tell you before, I believe all the Win32 tools do. I know I have seen a message stating the log and file cannot be the same and it aborted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 30, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Here is a fun one for you. If you set the log file to the dump file on you import it will of course wipe out your dump file. However, Oracle is nice enough to go ahead and tell you *after* it wipes out your dump file that setting your log file to your dump file is an invalid option! I converted a bunch of tablespaces to LMT this weekend and noticed that they required about 10% more space than the DD managed. I did not change any of the settings other than using UNIFORM extents of 128K for the most part. Some of the tablespaces had very few objects so the slack on small objects did not account for the increase %. I am sure this has been covered but a quick search of Usenet and metalink didn't give me anything. Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [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: Christopher Spence INET: [EMAIL PROTECTED] 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: [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 problem
hi, I have an export with WE8DEC, and i want do a full import on a database With WE8ISO8859P1 character set. But avery time i do it a have a problem when he want to create indexes with: ORA-01115: erreur E/S en lecture de blocs a partir du fic. 9 (bloc # 13) ORA-01110: fichier de donnJes 9: 'file' ORA-07372: sfrfb: erreur de lecture, lecture impossible du bloc demandJ du fich de BDD. HP-UX Error: 14: Bad address is this a bug of oracle ??? Oracle 7.3.4.0.0 HP-UX 10.20 thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
wow is that precision performance or what? :) -Original Message- Darren Sent: Friday, July 20, 2001 08:16 To: Multiple recipients of list ORACLE-L Or 21 /dev/null (One less character to type) -Original Message- Sent: July 20, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: Steve Sapovits INET: [EMAIL PROTECTED] 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: [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: Browett, Darren INET: [EMAIL PROTECTED] 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: [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: Mark Leith INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
run the script in background export.sh import.sh -Original Message- Sent: 20 July 2001 14:15 To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] 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: [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: Ramasamy, Baskar INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] 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: [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: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [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: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
W, Run the export with 'nohup' and optionally redirecting the 'standard error' and 'standard out' to another file. nohup exp ... or nohup exp ... 21 junk.log In the first case screen output will be redirected (default) to 'nohup.out' file. In the second case it is redirected to the junk.log file. HTH.. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Walter K [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Subject: Exp/Imp - suppress screen output? Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] 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: [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: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
1 is standard output 2 is standard error -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Exp/Imp - suppress screen output? Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] 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: [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: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [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: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] 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: [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: Anderson, Brian INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
You can code it like this: exp / tables=mike mike.log 21 output is in mike.log -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] 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: [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: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [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: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] 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: [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: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: Steve Sapovits INET: [EMAIL PROTECTED] 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: [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: Exp/Imp - suppress screen output?
Or 21 /dev/null (One less character to type) -Original Message- Sent: July 20, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [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: Steve Sapovits INET: [EMAIL PROTECTED] 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: [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: Browett, Darren INET: [EMAIL PROTECTED] 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: [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: Importing indexes with INDEXFILE in imp
On Wednesday 11 July 2001 09:11, Jesse, Rich wrote:
The problem I'm having is that the generated file contains CONNECT
schema commands for every schema that has an indexed table. Does
everybody just gather up all the passwords to all the schemas and manually
Rich,
Use a script to change the password for each user
and then change it back to whatever it was.
I've included one below that works well on unix.
It requires 2 scripts, both included at the end
of this post. The method used has the advantage
of saving the commands to put the correct password
in a script in /tmp should something go wrong and
your main script crashes without resetting the password.
If the file was
created so that the schema was prefixed to the TABLE instead of the INDEX,
I could have one CONNECT SYSTEM/MANAGER at the start and it would all work
fine.
Two words for that: Learn Perl.
There's nothing better for changing scripts
You can't create an index in schema B for a table in schema A
anyway, right?
Sure you can.
Anyone have any cool workarounds for this in 8.1.7? A cool
grep/awk/sed/perl script to move the schema prefixes from index to table in
the INDEXFILE-generated script, perhaps?
Oh, looky there. You mentioned Perl.
If I weren't going to be late for work, I'd do this now. Maybe
later.
Jared
--
-- become_user.sql
rem avoid messing up an account if something does not work!
whenever sqlerror exit
set pages 0 feed on verify off echo off term on
col bu_user new_value user_to_become noprint
col global_name new_value gname noprint
prompt bu.sql will save a users old password
prompt and assign a new one so that you
prompt ( the DBA ) can log in. Run the tmp
prompt script to restore the old password.
prompt
prompt
prompt User to become:
set term off feed off
select '1' bu_user from dual;
select global_name from global_name;
@@tmpfile
set term off feed off
define reset_script=_tmp_file_name_..reset.sql
spool reset_script
select 'alter user user_to_become identified by values ' || ||
password || || ';'
from dba_users
where username = upper('user_to_become')
/
prompt set feed on echo off pause off term on
select 'prompt Please remove reset_script after you are done' from dual;
prompt prompt
spool off
!chmod 640 reset_script
alter user user_to_become identified by dbatest
/
whenever sqlerror continue
set term on feed on
connect user_to_become/dbatest@gname
prompt
prompt The password for user_to_become@gname will be changed to 'dbatest'
prompt The script to restore the password is reset_script
prompt
prompt I am resetting the users password to its original setting now.
prompt
@reset_script
undef gname
undef 1
undef user_to_become
--
-- tmpfile.sql
-- create a temporary file name
-- it will be of the form /tmp/INSTANCE.USER.HSECS
-- the temp filename will be in the variable _tmp_file_name_
-- you must be able to select from v$timer for this to work
-- use rmfile to remove tmp files
set verify off feed off
set echo off pause off feed off term off
var tmpstamp_ varchar2(30);
var dbname_ varchar2(8);
declare
tmpsecs number;
secs varchar2(9);
sec_len integer := 0;
begin
select hsecs into tmpsecs from v$timer;
--dbms_output.enable(100);
--dbms_output.put_line('secs: ' || secs);
select to_char(tmpsecs)
into :tmpstamp_
from dual;
select lower(substr(global_name,1,instr(global_name,'.')-1))
into :dbname_
from global_name;
end;
/
col tmpstamp_ noprint new_value timestamp
col filetmp_ noprint new_value _tmp_file_name_
col dbname_ noprint new_value instance
select :tmpstamp_ tmpstamp_, :dbname_ dbname_ from dual;
select
'/tmp/' ||
'instance' ||
'.' ||
lower(user) || '.' ||
'timestamp' filetmp_
from dual
/
set term on
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
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: [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).
Importing indexes with INDEXFILE in imp
Hi, I'm doing a migration from 8.0.6.2 to 8.1.7.1 on HP/UX 11.0. Because of all sorts of storage manipulation and other fun stuff, I'm going to be using the export/import method. So, everything I've ever read or ever been taught about doing a full export/import on any database of even smallish sizes (20GB for us) is that it is much faster to use the INDEXFILE option of imp, then run it's generated script after the rest of the DB objects have been imp'd. The problem I'm having is that the generated file contains CONNECT schema commands for every schema that has an indexed table. Does everybody just gather up all the passwords to all the schemas and manually insert them into this file to get the damn thing to run? If the file was created so that the schema was prefixed to the TABLE instead of the INDEX, I could have one CONNECT SYSTEM/MANAGER at the start and it would all work fine. You can't create an index in schema B for a table in schema A anyway, right? Anyone have any cool workarounds for this in 8.1.7? A cool grep/awk/sed/perl script to move the schema prefixes from index to table in the INDEXFILE-generated script, perhaps? Trying not to reinvent the wheel on a process that shouldn't be this difficult Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
How do IMP EXP - SOS
Title: How do IMP EXP - SOS hi I need to do the IMP of a dmp file from Oracle 8i to 8.1.5 can you guys pls help me how to go about it with warm regards deewaker g v
RE: How do IMP EXP - SOS
Title: How do IMP & EXP - SOS Deewaker, You did not mention what is the version of Oracle 8i. I am assuming it is higher than Oracle 815. In this case do the following steps. 1. Take export of the schema using exp from Oracle 815. To do this , you can connect to your source database using a connect string thru tnsnames. 2. Once you have the dmp file, then use the imp of Oracle 815 to do import into Oracle 815. Rao [EMAIL PROTECTED] -Original Message-From: Deewaker G.V. [mailto:[EMAIL PROTECTED]]Sent: Monday, June 11, 2001 3:51 AMTo: Multiple recipients of list ORACLE-LSubject: How do IMP EXP - SOS hi I need to do the IMP of a dmp file from Oracle 8i to 8.1.5 can you guys pls help me how to go about it with warm regards deewaker g v
RE: How do IMP EXP - SOS
Title: How do IMP & EXP - SOS technet.oracle.com should give you everything you need under documentation. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Deewaker G.V. [mailto:[EMAIL PROTECTED]]Sent: Monday, June 11, 2001 3:51 AMTo: Multiple recipients of list ORACLE-LSubject: How do IMP EXP - SOS hi I need to do the IMP of a dmp file from Oracle 8i to 8.1.5 can you guys pls help me how to go about it with warm regards deewaker g v
imp-00002: échc d'ouverture de k:\ora
Hi, I performed an import job in oem 2.1 of some tables oracle database 7.3.2 into oracle 8.1.6 schema , the size of dump file is 10k, the dump file is in an other server novell 5.1 in a volume NWFS, for the link i mapped a virtual drive K, but the job failed in oem console with : --- D:\Oracle\Ora81\network\agentimp [EMAIL PROTECTED] file=K:\oramaj\exp12_05.dmp fromuser=user_gl1k touser=test log=D:\oracle\ora81\pexe\tlx3.log ignore=y Import: Release 8.1.6.0.0 - Production on Di Mai 20 13:56:08 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connecté à : Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production IMP-2: échec d'ouverture de K:\oramaj\exp12_05.dmp pour lecture Fichier d'import : EXPDAT.DMP ps : RDBMS Version: 8.1.6 Operating System and Version: Windows 2000 Error Number (if applicable): imp-2 Product : imp Product Version: 8.1.6 And the same job succeed when the dump file is in local drive NTFS. best regards, Nabila Mekkaoui dba oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INF/MEKKAOUI INET: [EMAIL PROTECTED] 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: [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).
