RE: Export / Import Question
Princeton have definitions for ClarifyCRM, Oracle Apps and PeopleSoft indicated on their website. I'd strongly suggest talking to their rep's if you are interested though... They have excellent support staff and have always been helpful. Plus I have been told, but don't specifically have figures, that their pricing is very good. In terms of configuration I defined all relationships for about 150 tables and then defined an access path - Which explains where to start doing the extract and then how to traverse up and down relationships to get all required data. I spent a week or two setting this up but at the time I was new to the system and didn't understand the relationships. Ongoing maintenance as the application evolves is always quick and easy. Other bonuses include the ability to move data between different DBMS technologies (DB2, Oracle, SQL Server, Informix, Sybase, etc), and is aware of native tools such as SQL Loader to speed things up. Can you tell I was impressed when I was introduced to this product? It was one tool I didn't mind being forced to implement. Jared Still <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc: Sent by: Subject: RE: Export / Import Question [EMAIL PROTECTED] .com 12/01/2004 13:04 Please respond to ORACLE-L A tool such as this would be much more useful if it were to come preconfigured for use with well known apps, such as SAP for instance. It doesn't per chance have such an option does it? Most ERP systems have far too many tables to try and do this on your own, unless you are working for a rather large company that can spare the expense. Jared On Sun, 2004-01-11 at 13:44, Mark Richard wrote: > > > > > Hi Ron, > > If it's going to be an ongoing occurance you might want to consider > Princeton Softech's "Relational Tools for Servers" suite. In particular, > the Move for Servers product. > > I use it to populate up to 20 different development / testing environments > with a relationally intact subset of data from production. If your > database has RI it's a breeze, but even if you don't have RI defined in the > database (like we don't) then you just have to teach it the relationships > once. Since our production environment is around 1.5TB, Move for Servers > makes it a breeze to just extract a sample of 500 customers - enough to > test almost all functionality but still nice and small. > > I highly recommend this product - and they aren't even paying me to say > that! > > Regards, > Mark. > > > > > > "Smith, Ron L." > <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > [EMAIL PROTECTED]Subject: RE: Export / Import Question > .com > > > 10/01/2004 04:29 > Please respond to > ORACLE-L > > > > > > > That would require effort and planning on their
RE: Export / Import Question
A tool such as this would be much more useful if it were to come preconfigured for use with well known apps, such as SAP for instance. It doesn't per chance have such an option does it? Most ERP systems have far too many tables to try and do this on your own, unless you are working for a rather large company that can spare the expense. Jared On Sun, 2004-01-11 at 13:44, Mark Richard wrote: > > > > > Hi Ron, > > If it's going to be an ongoing occurance you might want to consider > Princeton Softech's "Relational Tools for Servers" suite. In particular, > the Move for Servers product. > > I use it to populate up to 20 different development / testing environments > with a relationally intact subset of data from production. If your > database has RI it's a breeze, but even if you don't have RI defined in the > database (like we don't) then you just have to teach it the relationships > once. Since our production environment is around 1.5TB, Move for Servers > makes it a breeze to just extract a sample of 500 customers - enough to > test almost all functionality but still nice and small. > > I highly recommend this product - and they aren't even paying me to say > that! > > Regards, > Mark. > > > > > > > "Smith, Ron L." > > <[EMAIL PROTECTED]>To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > > [EMAIL PROTECTED]Subject: RE: Export / Import > Question > .com > > > > > > 10/01/2004 04:29 > > Please respond to > > ORACLE-L > > > > > > > > > > That would require effort and planning on their part. > > Ron > > -Original Message- > Sent: Friday, January 09, 2004 11:05 AM > To: Multiple recipients of list ORACLE-L > > > Ron - You may want to ask yourself what you're getting into. My > preference is that the developers be creating scripts to make their > procedure, function, trigger changes, along with detailed instructions > for installing them. I make my counteroffer that I will recover a copy > of the production database from backup from them. Then they can run > their scripts just like they or I am going to in production. On the > other hand, if you have a lot of time on your hands, the challenge of > just refreshing the data, disabling/reenabling constraints may amuse you > for an afternoon. Just kidding, sort of. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, January 09, 2004 8:09 AM > To: Multiple recipients of list ORACLE-L > > > I have a user who want to refresh only the DATA in a test database with > DATA from the production database. He does not want to replace any > procedures, functions, triggers, etc... > > My question is, if I do a full or user level export, then turn around > and do a full or user level import with IGNORE=Y (after truncating the > tables) will the procedures, functions, triggers be replaced anyway? I > have a feeling they will. > > If so, is there any way to prevent this? > > Thanks! > R Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.
RE: Export / Import Question
Hi Ron, If it's going to be an ongoing occurance you might want to consider Princeton Softech's "Relational Tools for Servers" suite. In particular, the Move for Servers product. I use it to populate up to 20 different development / testing environments with a relationally intact subset of data from production. If your database has RI it's a breeze, but even if you don't have RI defined in the database (like we don't) then you just have to teach it the relationships once. Since our production environment is around 1.5TB, Move for Servers makes it a breeze to just extract a sample of 500 customers - enough to test almost all functionality but still nice and small. I highly recommend this product - and they aren't even paying me to say that! Regards, Mark. "Smith, Ron L." <[EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED]Subject: RE: Export / Import Question .com 10/01/2004 04:29 Please respond to ORACLE-L That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --
RE: Export / Import Question
Ron - You have my sympathy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 11:30 AM To: Multiple recipients of list ORACLE-L That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Export / Import Question
On 01/09/2004 12:29:35 PM, "Smith, Ron L." wrote: > That would require effort and planning on their part. > > Ron Ron, are your developers little, bearded men that live in the swamps of Elbonia? Planning and effort are contrary to the elbonian customs, but Elbonians are cheap labor. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Export / Import Question
That would require effort and planning on their part. Ron -Original Message- Sent: Friday, January 09, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Export / Import Question
Ron - You may want to ask yourself what you're getting into. My preference is that the developers be creating scripts to make their procedure, function, trigger changes, along with detailed instructions for installing them. I make my counteroffer that I will recover a copy of the production database from backup from them. Then they can run their scripts just like they or I am going to in production. On the other hand, if you have a lot of time on your hands, the challenge of just refreshing the data, disabling/reenabling constraints may amuse you for an afternoon. Just kidding, sort of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Export / Import Question
Ron, I share your feeling. All stored objects are recreated with CREATE OR REPLACE - IGNORE=Y is inoperant for them. IMHO the best you can do is generate as many table-level exports as you have tables, with TRIGGERS=N. Of course, usual fun with constraints. On the bright side, you will be able to parallelize like crazy. At this stage, dumping to a flat file and using sqlldr might be an even better option than imp/exp. HTH S Faroult >- --- Original Message --- - >From: "Smith, Ron L." <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Fri, 09 Jan 2004 06:09:26 > >I have a user who want to refresh only the DATA in >a test database with >DATA from the production database. He does not >want to replace any >procedures, functions, triggers, etc... > >My question is, if I do a full or user level >export, then turn around >and do a full or user level import with IGNORE=Y >(after truncating the >tables) will the procedures, functions, triggers be >replaced anyway? I >have a feeling they will. > >If so, is there any way to prevent this? > >Thanks! >R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Export / Import Question
TRIGGERS=N On 01/09/2004 09:09:26 AM, "Smith, Ron L." wrote: > I have a user who want to refresh only the DATA in a test database with > DATA from the production database. He does not want to replace any > procedures, functions, triggers, etc... > > My question is, if I do a full or user level export, then turn around > and do a full or user level import with IGNORE=Y (after truncating the > tables) will the procedures, functions, triggers be replaced anyway? I > have a feeling they will. > > If so, is there any way to prevent this? > > Thanks! > R Smith > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Smith, Ron L. > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
Export / Import Question
I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace any procedures, functions, triggers, etc... My question is, if I do a full or user level export, then turn around and do a full or user level import with IGNORE=Y (after truncating the tables) will the procedures, functions, triggers be replaced anyway? I have a feeling they will. If so, is there any way to prevent this? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: IMPORT QUESTION
Hamid Alavi wrote: > > DEAR LIST, > How can I import from a dump file which has some partionioned table into > another user with no partitioning. > Thanks in Advance > > Hamid Alavi > > Office : 818-737-0526 > Cell phone : 818-416-5095 Create the tables first and IGNORE=Y -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: IMPORT QUESTION
Hamid - In the target schema, is the table already created? If it isn't, I would recommend that you create it before you import the data. Normally partitioned tables are quite large. Are you sure this import will complete in a reasonable time frame? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 22, 2003 3:34 PM To: Multiple recipients of list ORACLE-L DEAR LIST, How can I import from a dump file which has some partionioned table into another user with no partitioning. Thanks in Advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 === 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.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
IMPORT QUESTION
DEAR LIST, How can I import from a dump file which has some partionioned table into another user with no partitioning. Thanks in Advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 === 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.net -- Author: Hamid Alavi 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: import question
Do not believe him :) -Original Message- Sent: Monday, July 29, 2002 10:38 AM To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. While Export it just bypasses the SQL Evaluation buffer,make it faster and directly put things in TTC buffer recognized by Import of Oracle If that option was not selected, frequent commit would enable the checkpoint more often and thus LGWR writing the buffers to redo logs more often. Enable a buffer size which could be substantial high, so that more number of rows could be extracted from the Export file in an array thus boosting the perf. Thanks Vikas Khanna -Original Message- Sent: Monday, July 29, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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: Vikas Khanna 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: Khedr, Waleed 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: import question
>From the 8.1.7 docs: "Direct path Export extracts data much faster than a conventional path export. Direct path Export achieves this performance gain by reading data directly, bypassing the SQL command processing layer and saves on data copies whenever possible. In a direct path Export, data is read from disk into the buffer cache and rows are transferred directly to the Export client. The evaluating buffer is bypassed. The data is already in the format that Export expects, thus avoiding unnecessary data conversion. The data is transferred to the Export client, which then writes the data into the export file. " --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: > Dan: > >I believe the SQL on the outbound is eliminated. With DIRECT=Y, > the > Kernel performs I/O direct to the DMP file versus generating the > SELECT > statements to retrieve the data and then write out the data. > That's why > exports take far less time with DIRECT=Y. You are correct that > Redo WILL be > generated on the import side. > > Thank You > > Stephen P. Karniotis > Product Architect > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email: [EMAIL PROTECTED] > Web:www.compuware.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: import question
Title: RE: import question Dan: I believe the SQL on the outbound is eliminated. With DIRECT=Y, the Kernel performs I/O direct to the DMP file versus generating the SELECT statements to retrieve the data and then write out the data. That’s why exports take far less time with DIRECT=Y. You are correct that Redo WILL be generated on the import side. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Straub, Dan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: import question > > If the Export has been taken with DIRECT = Y, meaning that the SQL > Evaluation buffer has to be bypassed then Import would not generate the Redo > buffer while Importing back the objects and the relevant data. > Very interesting, except that I believe you are wrong. ALL of my exports are done with direct=y option. I can demonstrate very easily that there will be 'redo' generated when doing the import by putting the importing database into archivelog mode and turning off the archiver process. If redo is not being produced (as you state), why do I see messages in the alert log telling me that the database is halted because all my redo logs are full and need archiving? Have a nice day, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
RE: import question
Hi, I've never seen anything to suggest that exportijng using DIRECT=Y speeded up subsequent imports. I'd be interested to know if this is really the case but I doubt it. The structure of an export file is exactly the same whatever the DIRECT setting. But I've been wrong before ... Things I'd suggest would be: - Optimise your online redos - usual advice; pretty big, raw devices, watch for log switch interval. - Switch off archivelogging. - Offline all but one, large rollback segment and specify COMMIT=N to delay commits until the end of each object. - Postpone index creation until the import has finished. Create indexes after the import is completed using the NOLOGGING option (and maybe in parallel too). - Make sure that you have BUFFER set large enough. 1M-5M is sensible. - In the olden days there used to be some benefit in relinking the imp executable to use single-task mode rather than two-task. I haven't tested this recently; can anyone confirm that there's still a benefit? - separate your I/O. Your DB may already be optimised. But your expoprt file on a different disk again. - Also you may be able to run parallel import streams - you be the judge; just a thought. Obviously some of these suggestions may not suit your needs. Regards, Mike Hately Oracle DBA -Original Message- Sent: 29 July 2002 15:38 To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. While Export it just bypasses the SQL Evaluation buffer,make it faster and directly put things in TTC buffer recognized by Import of Oracle If that option was not selected, frequent commit would enable the checkpoint more often and thus LGWR writing the buffers to redo logs more often. Enable a buffer size which could be substantial high, so that more number of rows could be extracted from the Export file in an array thus boosting the perf. Thanks Vikas Khanna -Original Message- Sent: Monday, July 29, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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: import question
Title: RE: import question > > If the Export has been taken with DIRECT = Y, meaning that the SQL > Evaluation buffer has to be bypassed then Import would not generate the Redo > buffer while Importing back the objects and the relevant data. > Very interesting, except that I believe you are wrong. ALL of my exports are done with direct=y option. I can demonstrate very easily that there will be 'redo' generated when doing the import by putting the importing database into archivelog mode and turning off the archiver process. If redo is not being produced (as you state), why do I see messages in the alert log telling me that the database is halted because all my redo logs are full and need archiving? Have a nice day, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
RE: import question
Vikas, Where did you find this information? I would appreciate any and all references. Thanks. - Kirti -Original Message- Sent: Monday, July 29, 2002 9:38 AM To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. -- 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: import question
If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. While Export it just bypasses the SQL Evaluation buffer,make it faster and directly put things in TTC buffer recognized by Import of Oracle If that option was not selected, frequent commit would enable the checkpoint more often and thus LGWR writing the buffers to redo logs more often. Enable a buffer size which could be substantial high, so that more number of rows could be extracted from the Export file in an array thus boosting the perf. Thanks Vikas Khanna -Original Message- Sent: Monday, July 29, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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: Vikas Khanna 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).
import question
Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia 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: IMPORT QUESTION
Hello Seema You will have to use incremental export AND incremental import. Incremental export will export only the tables that were updated. Incremental import will DROP these tables and then will create them and import data into them. The difference between regular import and incremental import is that regular import assume that the tables does not exist and gives errors if a table exist (of course you can ignore them). Incremental import assumes that the tables already exist in the database and will drop them and create them again. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 28, 2002 6:03 PM > To: Multiple recipients of list ORACLE-L > Subject: IMPORT QUESTION > > Hi > I want to switch database from one server to another server.I want do data > > migration thru export/import.How can I run incremental import.Is it > necessary to have incremental export? > I want to migrate data thru export/import.What ever the tables updated > during import on old server I want to do reimport on new serevr.There is > one > parameter INCTYPE is available in export/import both.Is it necessary to > have > incremental export to take incremental import? > Please suggest. > Thx > -seema > > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp.; > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= 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).
IMPORT QUESTION
Hi I want to switch database from one server to another server.I want do data migration thru export/import.How can I run incremental import.Is it necessary to have incremental export? I want to migrate data thru export/import.What ever the tables updated during import on old server I want to do reimport on new serevr.There is one parameter INCTYPE is available in export/import both.Is it necessary to have incremental export to take incremental import? Please suggest. Thx -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Export/Import question
Jared or Bruce: For everyone's sanity, please unsubscribe [EMAIL PROTECTED] who seems to have a major problem and is just an annoyance to other list members. Arich Henneman wrote: > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arich Henneman > 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: Charlie Mengler 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: Export/Import question
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman 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: Export/Import question
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman 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: Export/Import question
Sujatha Madan wrote: > > How come I am getting only blank mails?? ... see below > > -Original Message- > Sent: Thursday, 6 September 2001 11:35 AM > To: Multiple recipients of list ORACLE-L > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arich Henneman > INET: [EMAIL PROTECTED] > Sujatha, Because someone that is about to get unsubscribed from this list has either: - a poorly configured autoresponder - a virus Jared or Bruce will likely handle this shortly. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Export/Import question
How come I am getting only blank mails?? ... see below -Original Message- Sent: Thursday, 6 September 2001 11:35 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman 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: Sujatha Madan 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: Export/Import question
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman 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: Export/Import question
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman 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: Export/Import question
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman 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: Export/Import question
it's part of the import functionality when you do a full database import. I used to use it as part of a contingency strategy when I had a site doing noarchivelog. We'd do a full database export, move to the contingency machine, build a minimal database (system, rbs and temp) and then do a full database import. Voila, Oracle would look for tablespaces and would recreate them if they weren't there. Do a show=y to a log file of a full database dump and you'll see tablespace create statements. >From: "Eric D. Pierce" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Export/Import question >Date: Wed, 05 Sep 2001 13:35:51 -0800 > >Wow! Please elaborate! > > > > -- > > > > From: "Jonathan Lewis" <[EMAIL PROTECTED]> > > Date: Tue, 4 Sep 2001 20:47:08 +0100 > > Subject: Re: Export/Import question > >[via ORACLE-L Digest -- Volume 2001, Number 248] > >... > > If the tablespaces for the data do not currently > > exist, then Oracle will try to create them on > > the wrong drive. >... > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Eric D. Pierce > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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).
Re: Export/Import question
Wow! Please elaborate! > -- > > From: "Jonathan Lewis" <[EMAIL PROTECTED]> > Date: Tue, 4 Sep 2001 20:47:08 +0100 > Subject: Re: Export/Import question [via ORACLE-L Digest -- Volume 2001, Number 248] ... > If the tablespaces for the data do not currently > exist, then Oracle will try to create them on > the wrong drive. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Export/Import question
Dave, Hopefully someone else already answered better, but if not, it is the database alias in your connect string. Wherever the database is for that alias is where the import will end up. Of course as with all things Oracle, it probably won't be quite that simple, you may need to change network config, pre-build tables and stuff, etc. regards, ep > > -- > > From: "Farnsworth, Dave" <[EMAIL PROTECTED]> > Date: Tue, 4 Sep 2001 13:55:48 -0500 > Subject: Export/Import question [via ORACLE-L Digest -- Volume 2001, Number 248] ... > EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y > > The export ran with no errors or warnings. Now, since my datafiles reside > on drive e will the import then be looking for drive e to place the data in. > I do not see any option to specify where I want the data to go. Or if I run > the import from the f drive of the destination server will the import > utility place the data in drive F. > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Export/Import question
I've heard that the problem is not on OS level but on filesystem. So, is it possible to move db file between different OS, but leave the files on the same HDD (on the same filesystem type)??? JP Dne st 5. zá?í 2001 22:17 jste napsal(a): > If you have enough time for keeping your database down then as you said you > can experiment on it,cause the export import definetly takes time, it is > better to ship the files and bring up the database. > Recently I had an issue of moving a database from NT TO unix that too from > 7.3.4 to 8.1.7,Man it was too slow.If the database files were portable > across operating systems then shipping files would have made my life more > easier. > Well all the best > > > From: Stephane Faroult <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Export/Import question > >Date: Wed, 05 Sep 2001 05:26:35 -0800 > > > >Farnsworth, Dave wrote: > > > Arun, > > > > > > Thanks for the suggestion. I am doing export/import because I do not > > > >know > > > > > how to ship a database to another server. For that matter, I am doing > > > export/import for the first time. I figured that since our DB is not a > > > >24X7 > > > > > that I could get a clean export. I guess I have to get my hands dirty > > > >at > > > > > some point and learn about export/import. When I can do that > > > >successfully > > > > > then maybe I can move on and learn about shipping a database. One > > > small step at a time but I am having fun doing it!! :-) > > > > > > Dave > > > >Dave, > > > > Before you get your hands too dirty, you may be interested by the > >following paper: > > > >http://www.oriolecorp.com/ExpImp.html > > > >-- > >HTH, > > > > Stephane Faroult > > Oriole Corporation > >-- > >http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs > >-- > >-- > >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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Export/Import question
If you have enough time for keeping your database down then as you said you can experiment on it,cause the export import definetly takes time, it is better to ship the files and bring up the database. Recently I had an issue of moving a database from NT TO unix that too from 7.3.4 to 8.1.7,Man it was too slow.If the database files were portable across operating systems then shipping files would have made my life more easier. Well all the best >From: Stephane Faroult <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Export/Import question >Date: Wed, 05 Sep 2001 05:26:35 -0800 > >Farnsworth, Dave wrote: > > > > Arun, > > > > Thanks for the suggestion. I am doing export/import because I do not >know > > how to ship a database to another server. For that matter, I am doing > > export/import for the first time. I figured that since our DB is not a >24X7 > > that I could get a clean export. I guess I have to get my hands dirty >at > > some point and learn about export/import. When I can do that >successfully > > then maybe I can move on and learn about shipping a database. One small > > step at a time but I am having fun doing it!! :-) > > > > Dave > > > >Dave, > > Before you get your hands too dirty, you may be interested by the >following paper: > >http://www.oriolecorp.com/ExpImp.html > >-- >HTH, > > Stephane Faroult > Oriole Corporation >-- >http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs >-- >-- >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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C 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: Export/Import question
Hi, I sort of agree with this, but had a little bit of a different idea. I guess depending on the size of the user and how many other users it may dependant on, why don't you just export the user? If you are exporting the db, that means you already have Oracle installed on the other machine. I don't, just seems like it would be quicker and easier than exporting the whole db or making a copy of it. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Export/Import question
Farnsworth, Dave wrote: > > Arun, > > Thanks for the suggestion. I am doing export/import because I do not know > how to ship a database to another server. For that matter, I am doing > export/import for the first time. I figured that since our DB is not a 24X7 > that I could get a clean export. I guess I have to get my hands dirty at > some point and learn about export/import. When I can do that successfully > then maybe I can move on and learn about shipping a database. One small > step at a time but I am having fun doing it!! :-) > > Dave > Dave, Before you get your hands too dirty, you may be interested by the following paper: http://www.oriolecorp.com/ExpImp.html -- HTH, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- 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: Export/Import question
First of all why do u have to do the import and export why dont u ship the whole database across, if you want to rename the database create a service and start service and bring up the database. I feel that is much better than doing the whole export and import across. >From: "Farnsworth, Dave" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Export/Import question >Date: Wed, 05 Sep 2001 03:20:56 -0800 > >Thanks Tom and others that replied, > >That was the explanation that I needed. I also was informed that exporting >with COMPRESS=Y is a mistake due to sizing issues so I will do another >export with COMPRESS=N. > >Dave > >-Original Message- >Sent: Tuesday, September 04, 2001 3:48 PM >To: Multiple recipients of list ORACLE-L > > >Dave, > >You will need to create the tablespaces before you do the import. When you >create the tablespaces, you will be creating the physical files to support >those tablespaces. > >Import simply imports data to tablespaces (or, optionally, other >tablespaces). > >Sooo, when you re-create your new tablespaces, you can place the physical >files anyplace you want on the new server. > >hope this helps. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Tuesday, September 04, 2001 4:02 PM >To: Multiple recipients of list ORACLE-L > > >I have a question about how the export/import utility works. My situation >is that damagement had me put my live and test environments on the same >server. Now they realize that this is not a good situation(test has >crashed >the server a few times and required a re-boot, imagine that). I have >Oracle >8.1.7 running on Windoze NT 4.0. I have to move my live database to >another >server. From reading the fine manuals and from posts that I have seen I >have decided to use the export/import utility to make my move. My database >is inactive for the weekend. What I am not sure of is this, on my current >live database my datafiles(.dbf) reside on drive E. The server I am moving >to has a drive F that will be for my data. I have done the export using >this command; > >EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y > >The export ran with no errors or warnings. Now, since my datafiles reside >on drive e will the import then be looking for drive e to place the data >in. >I do not see any option to specify where I want the data to go. Or if I >run >the import from the f drive of the destination server will the import >utility place the data in drive F. > >Thanks, > >Dave >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Farnsworth, Dave > 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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Farnsworth, Dave > 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 inform
RE: Export/Import question
Arun, Thanks for the suggestion. I am doing export/import because I do not know how to ship a database to another server. For that matter, I am doing export/import for the first time. I figured that since our DB is not a 24X7 that I could get a clean export. I guess I have to get my hands dirty at some point and learn about export/import. When I can do that successfully then maybe I can move on and learn about shipping a database. One small step at a time but I am having fun doing it!! :-) Dave -Original Message- Sent: Wednesday, September 05, 2001 7:12 AM To: Multiple recipients of list ORACLE-L First of all why do u have to do the import and export why dont u ship the whole database across, if you want to rename the database create a service and start service and bring up the database. I feel that is much better than doing the whole export and import across. >From: "Farnsworth, Dave" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Export/Import question >Date: Wed, 05 Sep 2001 03:20:56 -0800 > >Thanks Tom and others that replied, > >That was the explanation that I needed. I also was informed that exporting >with COMPRESS=Y is a mistake due to sizing issues so I will do another >export with COMPRESS=N. > >Dave > >-Original Message- >Sent: Tuesday, September 04, 2001 3:48 PM >To: Multiple recipients of list ORACLE-L > > >Dave, > >You will need to create the tablespaces before you do the import. When you >create the tablespaces, you will be creating the physical files to support >those tablespaces. > >Import simply imports data to tablespaces (or, optionally, other >tablespaces). > >Sooo, when you re-create your new tablespaces, you can place the physical >files anyplace you want on the new server. > >hope this helps. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Tuesday, September 04, 2001 4:02 PM >To: Multiple recipients of list ORACLE-L > > >I have a question about how the export/import utility works. My situation >is that damagement had me put my live and test environments on the same >server. Now they realize that this is not a good situation(test has >crashed >the server a few times and required a re-boot, imagine that). I have >Oracle >8.1.7 running on Windoze NT 4.0. I have to move my live database to >another >server. From reading the fine manuals and from posts that I have seen I >have decided to use the export/import utility to make my move. My database >is inactive for the weekend. What I am not sure of is this, on my current >live database my datafiles(.dbf) reside on drive E. The server I am moving >to has a drive F that will be for my data. I have done the export using >this command; > >EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y > >The export ran with no errors or warnings. Now, since my datafiles reside >on drive e will the import then be looking for drive e to place the data >in. >I do not see any option to specify where I want the data to go. Or if I >run >the import from the f drive of the destination server will the import >utility place the data in drive F. > >Thanks, > >Dave >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Farnsworth, Dave > 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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >--
RE: Export/Import question
Thanks Tom and others that replied, That was the explanation that I needed. I also was informed that exporting with COMPRESS=Y is a mistake due to sizing issues so I will do another export with COMPRESS=N. Dave -Original Message- Sent: Tuesday, September 04, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Dave, You will need to create the tablespaces before you do the import. When you create the tablespaces, you will be creating the physical files to support those tablespaces. Import simply imports data to tablespaces (or, optionally, other tablespaces). Sooo, when you re-create your new tablespaces, you can place the physical files anyplace you want on the new server. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 04, 2001 4:02 PM To: Multiple recipients of list ORACLE-L I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command; EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Export/Import question
Dave, Import does the things in a LOGICAL way, I mean to say, what actually import does is, it connects to already existing database as one of the database users and does all necessary DDLs and DMLs (and whatever)to have the data ready for you, as per the contents of dmp file and your import options.So it is not bothered about the PHYSICAL locations of data files. hth, Suren -Original Message- Sent: Tuesday, September 04, 2001 4:02 PM To: Multiple recipients of list ORACLE-L I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command; EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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).
Re: Export/Import question
As ever, the answer is dependent on the current state of play. If the tablespaces for the data do not currently exist, then Oracle will try to create them on the wrong drive. If the tablespaces do exist, it doesn't matter where they exist - so long as they are large enough. Exporting with COMPRESS=Y was probably a mistake, though. This tends to ensure that all the imported objects will be different sizes and give you the maximum opportunity for future re-org hassles. If you have the time, I would export again without the compress, then pre-create the tablespaces on the target machine using locally managed tablespaces of uniform extent sizes. Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 04 September 2001 20:24 |I have a question about how the export/import utility works. My situation |is that damagement had me put my live and test environments on the same |server. Now they realize that this is not a good situation(test has crashed |the server a few times and required a re-boot, imagine that). I have Oracle |8.1.7 running on Windoze NT 4.0. I have to move my live database to another |server. From reading the fine manuals and from posts that I have seen I |have decided to use the export/import utility to make my move. My database |is inactive for the weekend. What I am not sure of is this, on my current |live database my datafiles(.dbf) reside on drive E. The server I am moving |to has a drive F that will be for my data. I have done the export using |this command; | |EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y | |The export ran with no errors or warnings. Now, since my datafiles reside |on drive e will the import then be looking for drive e to place the data in. |I do not see any option to specify where I want the data to go. Or if I run |the import from the f drive of the destination server will the import |utility place the data in drive F. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Export/Import question
Dave, You will need to create the tablespaces before you do the import. When you create the tablespaces, you will be creating the physical files to support those tablespaces. Import simply imports data to tablespaces (or, optionally, other tablespaces). Sooo, when you re-create your new tablespaces, you can place the physical files anyplace you want on the new server. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 04, 2001 4:02 PM To: Multiple recipients of list ORACLE-L I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command; EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Export/Import question
Create all tablespaces(same name as in the source database) before you import. -Original Message- Dave Sent: Tuesday, September 04, 2001 4:02 PM To: Multiple recipients of list ORACLE-L I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command; EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Uday C Basavaraj 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: Export/Import question
The data is stored based on tablespaces and not physical mount points. You doing file=x tells it where to store the single export file, but the data is stored internally to tablespaces and such. "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- Sent: Tuesday, September 04, 2001 4:02 PM To: Multiple recipients of list ORACLE-L I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command; EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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).
Export/Import question
I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command; EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: import question ???
Title: RE: import question ??? > -Original Message- > From: Leslie Lu [mailto:[EMAIL PROTECTED]] > > Are there any size limitation for import file? I got > a dmp file Amin.dmp with 9706720291 bytes, when I > imported it, I got: > > IMP-2: failed to open Amin.dmp for read > IMP-00021: operating system error - error code (dec > 79, hex 0x4F) > > Is the file corrupted or the file is too big? Thanks. What version of imp/exp? The size limit for some versions of 8.0 and 7.3.4 is 2GB, so your dmp file isn't too big. Did you FTP the dmp file from one server to another in ASCII mode? A dmp file whould be FTPed in binary mode. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com
Re: [import question ???]
If you received the file through FTP, make sure it was a binary file transfer. Yigal Leslie Lu <[EMAIL PROTECTED]> wrote: > Hi all, > > Are there any size limitation for import file? I got > a dmp file Amin.dmp with 9706720291 bytes, when I > imported it, I got: > > IMP-2: failed to open Amin.dmp for read > IMP-00021: operating system error - error code (dec > 79, hex 0x4F) > > Is the file corrupted or the file is too big? Thanks. > > > Leslie > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Leslie Lu > 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). Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran 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: import question ???
More than likely too big, why does export(32-bit) let you write out one that large, i have no idea. We had a developer here do it and i can't duplicate it, when i run export 2G and it chokes, he got a 15G file. aix 64bit, oracle 32 bit. go figure. joe >>> [EMAIL PROTECTED] 08/01/01 02:10PM >>>Hi all,Are there any size limitation for import file? I gota dmp file Amin.dmp with 9706720291 bytes, when Iimported it, I got:IMP-2: failed to open Amin.dmp for readIMP-00021: operating system error - error code (dec79, hex 0x4F)Is the file corrupted or the file is too big? Thanks.Leslie__Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Leslie Lu 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: import question ???
There us a 2 gig limit on the size of the .dmp file. Try doing the export and import compressed through pipes. Check Metalink for references on compressed import and export. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 2:10 PM > Hi all, > > Are there any size limitation for import file? I got > a dmp file Amin.dmp with 9706720291 bytes, when I > imported it, I got: > > IMP-2: failed to open Amin.dmp for read > IMP-00021: operating system error - error code (dec > 79, hex 0x4F) > > Is the file corrupted or the file is too big? Thanks. > > > Leslie > > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Leslie Lu > 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: 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).
import question ???
Hi all, Are there any size limitation for import file? I got a dmp file Amin.dmp with 9706720291 bytes, when I imported it, I got: IMP-2: failed to open Amin.dmp for read IMP-00021: operating system error - error code (dec 79, hex 0x4F) Is the file corrupted or the file is too big? Thanks. Leslie __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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).