Imp of all users tables

List, How would I import all of one users tables (544) without listing all of them in the tables= option? I am using: imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y file=expdat.dmp How can I do all (and not a full=y) of the 544 tables for one user at one time? thanks

RE: Imp of all users tables

-Original Message- imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y file=expdat.dmp How can I do all (and not a full=y) of the 544 tables for one user at one time? Leave out the tables=. Then it will default

IMP-00098: Internal Error: impccr2

Hi all, I received quite interesting error during import. I am trying to put the dump from 8.1.6 database to 9i rel2 database on win2k server. The export dump was done with WE8ISO8859P1 character set and the target db is with UTF8 character set... Do you have any idea, or should I contact oracle

RE: full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user ifyou have toimport all indexes,constraints to a single tablespacethenfollowing procedurewillwork 4)After importing datachange the default tablespace to index tablespace ,ensure that no other ts quota(except index ts) is given

RE: full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user oh - I like that! thanks! -Original Message-From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]]Sent: Friday, November 08, 2002 2:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp

RE: full exp/imp of user to new tablespace; same user

Title: RE: full exp/imp of user to new tablespace; same user A quick note to those that downloaded a version of DBATool yesterday following on from my message, and to all those that have a past version as well. The download link on the DBATool web page hadn't been updated for the new

RE: full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user Choudhary out of curiousity, is itunderstood that you will need todrop the same recently imported indexes from the data TS before running the import into the index TS ? or will subsequent import cause a rebuild on the incoming

full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other

Re: full exp/imp of user to new tablespace; same user

Markham, Richard wrote: I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export;

RE: full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure

RE: full exp/imp of user to new tablespace; same user

-Original Message- I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export;

RE: full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user Extra security could be to give zero quota on other tablespaces. -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: donderdag 7 november 2002 14:59To: Multiple recipients of list ORACLE-LSubject

RE: full exp/imp of user to new tablespace; same user

And if all else fails (not that the advice already given will!), we have a tool that can manipulate the DDL for the users objects VERY quickly and easily, through a rule based change (e.g. Modify ALL tables storage clauses within USERS schema to TABLESPACE):

RE: full exp/imp of user to new tablespace; same user

Title: RE: full exp/imp of user to new tablespace; same user well now I can say I'm spoiled. I was given more than enough information to to accomplish the task (done) and a new tool to boot! =) Thanks alot everyone. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED

RE: full exp/imp of user to new tablespace; same user

: [EMAIL PROTECTED] Subject: RE: full exp/imp of user to new tablespace; same user

imp/exp question

Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA with the default tablescape tabA

RE: imp/exp question

Dear One of the solution is you can export in system user with two user tables. You can exp/ imp blob column also. Later you can imp thru system, but use from user and to user options. I think it will help u. Thanks and Regards V.Baskaran -Original Message- Ciocildau Sent

Re: imp/exp question

Adrian Ciocildau wrote: Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with imp/exp. I'll try to explain it a little bit more. we have userA

Re: imp/exp question

Hi, what do you mean with to export in system user with two user tables ? Regards, Adrian Ciocildau Oracle wrote: Dear One of the solution is you can export in system user with two user tables. You can exp/ imp blob column also. Later you can imp thru system, but use from user and to user

exp/imp bug - Note:199416.1

Has anybody put on the patch to resolve this. On Nt, looks like fixed in 8.1.7.4.5. However, searching on the bug 2410612 reveals two other corruption bugs that appear unresolved. Have people put this patch on or waiting for a complete resolution. Jeffrey BeckstromDatabase

RE: [Q] imp/exp error on 9iR2?

will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL connect / as sysdba Connected. SQL alter user sys identified by change_on_install User altered

[Q] imp/exp error on 9iR2?

I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c

Re: [Q] imp/exp error on 9iR2?

It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c

Please need some help on imp

Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA

RE: Please need some help on imp

Bill, I assume from the way you state this, you already have the tables built and don't want imp to blow up trying to recreate them. Correct? If so, try ignore=y. Also, if the user is changing, are you using fromuser= touser=? Output from your problem might be helpful. HtH, John P

RE: Please need some help on imp

Bill Ignore=Y is that what you're looking for? Mike -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just

Re: Please need some help on imp

I assume that the schemas, tables, synonyms, roles, grants, etc already exist and you just want to populate the tables with the data from your other database. In your parm file set IGNORE=Y. This will ignore errors caused by already created objects and just load the data. Type: imp help=y

Re: Please need some help on imp

, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill

RE: IMP/EXP Problem

aprox 20 min across a dblink as compaired to hours with an exp/imp combination. ROR mª¿ªm [EMAIL PROTECTED] 07/18/02 01:55PM Dennis, I allow IMP to create it. -Original Message- Sent: Thursday, July 18, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hamid Did you pre

IMP/EXP Problem

Dear List, I am trying to import a table from another database which has partitioning, so after got few errors regarding the specific tablespace when I create the same tablespace it start loading data but after few thousand records stop with ORA-00018, my question is if we have a table which

RE: IMP/EXP Problem

Hamid Did you pre-create the table on your target database, or are you allowing imp to create it? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Dear List, I am trying

RE: IMP/EXP Problem

Dennis, I allow IMP to create it. -Original Message- Sent: Thursday, July 18, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Hamid Did you pre-create the table on your target database, or are you allowing imp to create it? Dennis Williams DBA Lifetouch, Inc. [EMAIL

Re: Exp Imp User ?

utilities guide, happy reading. guess who wrote: I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user ,

Exp Imp User ?

I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump of scott user , then that scott dump should be incorporated into the

Re: Exp Imp User ?

RTFM Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 18 Jun 2002 20:33:20 -0800 I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after

RE: Exp Imp User ?

All your questions are clearly answered in the Oracle Utilities Guide. Available (Free) at http://tahiti.oracle.com/pls/db92/db92.homepage?remark=tahiti. Try it. - Kirti -Original Message- Sent: Tuesday, June 18, 2002 11:33 PM To: Multiple recipients of list ORACLE-L I want to

Re: Exp Imp User ?

] cc: Fax to: Subject:Exp Imp User ? I want to know the export and import commands(SYNTAX). Then i want to know what are all the steps(commands) to be done for creating a new user such that after creating i have to use the above two commands and to take a dump

RE: Exp Imp User ?

/server.817/ a76955/ch02.htm RC -Original Message- From: guess who [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 June 2002 14:33 To: Multiple recipients of list ORACLE-L Subject: Exp Imp User ? I want to know the export and import commands(SYNTAX). Then i want to know what

RE: Exp/Imp Errors: Tablespace Specific?

imported IMP-00015: following statement failed because the object already exists: ALTER TABLE ACCOUNT ADD CONSTRAINT PK_ACCOUNT PRIMARY KEY (ACCOUNT_ID ,GENERATION) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INIT IAL 8388608) TABLESPACE AURDEV_TS ENABLE Also, had it added one trigger

Exp/Imp Errors: Tablespace Specific?

LE " Also, had it added one trigger twice (may NOT be a related issue) - I deleted the extra trigger and recompiled it and it was fine (but it was weird to see two with same name). Also, received errors on ALL of the FKs (as the referencing PKs did not exist). IMP-3: ORACLE e

exp/imp question

List, Source database 7.3.4 OS Novell 4.2 Target database 8.1.7 OS Linux RedHat 7.2 Table is 5 columns ,indexes on columns 1,2PK, 1,3 , 3 for application usage Export of a table is 750K rows and takes about 2 minutes with a DMP file the size of 20 Meg. Import command in the V$SQLAREA shows

Re: exp/imp question

I would take a look at v$session_wait whilst the import is running and see what pops up. My understanding of NESTED_TABLE_SET_REFS is to get at the hidden columns when object data types are used. I'm not sure why it always seems to be so prevalent in import - possibly they just do it with any

Re: Trouble with imp on 8.1.6

What does your imp command look like? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team

Re: Trouble with imp on 8.1.6

HI Rick, Could you share with us the export statement and the import statement you used. Tha will help figure out what went wrong. John [EMAIL PROTECTED] wrote: Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following

RE: Trouble with imp on 8.1.6

Rick, By default Oracle will import from/to the same user only. You can do what you want by using the fromuser/touser option. Something like imp user/pwd file=x.dmp fromuser=from touser=to Type imp help=y for the specifics. Hope this helps. Tom Mercadante Oracle Certified Professional

Re: Trouble with imp on 8.1.6

imp user/pass@service file=file.dmp log=test.log fromuser=caler touser=newuser tables=(*) I have also done above with charset=us7ascii no difference Rick

Re: Trouble with imp on 8.1.6

exp system/pass@service file=file.dmp log=exp.log user=(adtlite) The exp.log shows all objects exported correctly. imp system/pass@service file=file.dmp log=test.log fromuser=system touser=caler tables=(*) Rick

IMP/EXP b/w 8.1.7 and 8.1.6

data from 8.1.7 and then "imp" to import in it. But will that work? Or I have to set some COMPATIBLE parameter on 8.1.7/8.1.6 init file?? Thanks in advance Arslan Zaheer Dar

Exp / Imp Utility Questions

to my questions in the documentation. 1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures? 2. The conversion DB that I have only has the tables, PK's, FK's, and indexes and no triggers, functions, cursors, etc

RE: Exp / Imp Utility Questions

Title: RE: Exp / Imp Utility Questions 1) You cannot have read the docs to well not to know the answer to Q1 Hint - look at the ignore parameter to imp 2) It all depends if the triggers have been run once to change the data that is now in the conversion db. You may have a trigger that adds 1

Re: Exp / Imp Utility Questions

have not found the answers to my questions in the documentation. 1. Can I use Exp / Imp to just move the data? Or, does this utility move the data and the table structures? If you do not specify IGNORE=Y, if the table already exists (which I presume is the case since you only

RE: Exp / Imp Utility Questions

You can use imp to move just the data. Just set ignore=y so that when the object already exists it will move on. You are right about the FK's and disabling them. As for triggers, it really depends on whether or not you want them to fire... -Original Message- Sent: Friday, December 28

Exp/Imp Utility

If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am importing to, will Imp generate an error? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN

RE: Exp/Imp Utility

Hell yes! Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 20, 2001 12:46 PM To: Multiple recipients of list ORACLE-L If I use Exp / Imp utility to just extract and load

Re: Exp/Imp Utility

It sure will. --- Ken Janusz [EMAIL PROTECTED] wrote: If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am importing to, will Imp generate an error? Thanks, Ken Janusz, CPIM Database

Re: Exp/Imp Utility

read the fine manuals you cannot import into a table that has a different definition of columns. --- Ken Janusz [EMAIL PROTECTED] wrote: If I use Exp / Imp utility to just extract and load data into an existing DB. If there are more columns in the input record that in the DB table I am

Weid exp/imp problem

Title: Weid exp/imp problem Hi! I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical. What I do is this: - export user (using exp) from development. Works flawlessly

Re: Weid exp/imp problem

imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK FOREIGN KEY (BNGR_ID) REFERENCES BENUTZER_GRUPPEN (ID) ENABLE NOVALIDATE IMP-3: ORACLE

Re: Weid exp/imp problem

imported . . importing tableUSEREXIT_TYPE 3 rows imported . . importing table ZYKLUS 7 rows imported IMP-00017: following statement failed with ORACLE error 2270: ALTER TABLE BENUTZER_GRUPPEN_ZUORD ADD CONSTRAINT BNGRZ_BNGR_FK

RE: Weid exp/imp problem

Title: Weid exp/imp problem This error is coming because at the time of adding foreign key constraint , referencing primary key is not available. You can avoid this error by creating a similar schema in the user in which you are taking the import and then import data with parameter

RE: Weid exp/imp problem

You can handle this by two ways. The first is running the imp in two times. And the second imp with rows=n and ignore=y. On the other hand, you can create all the objects with the constraints INITIALLY DEFERRED. With the precaution that you can not undo the mode of the constraint with an alter

RE: Weid exp/imp problem

Title: Weid exp/imp problem Helmut: This could be due to the fact that constraints on those tables have not been defined yet. Since tables are imported in Alpha order, I would suggest performing a no-data import after this one is complete. Thank You Stephen P. Karniotis

RE: Weid exp/imp problem

Title: Weid exp/imp problem You may need to use consistent=y on the export to ensure that the view for the entire export run is from one snapshot in time. If your application is busy changing data during the export, then as export moves through the list of tables (alphabetically I think

exp/imp unable to create unix index

Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist in test database exporting tablePA_PROJECTS_ALL 3160 rows exported

AW: exp/imp unable to create unix index

18:40 An: Multiple recipients of list ORACLE-L Betreff: exp/imp unable to create unix index Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp and exp log that record exp/imp is the same while unique index still exist

Re: exp/imp unable to create unix index

from your PC! http://www.eboom.com/free/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 10, 2001 09:40 AM Hi gurus I had oracle1452 when imp/exp database from test to prod databases. I have no idea why but found out from both imp

IMP-00037 Character marker set unknown

Hi DBAs, I trying to import uncorrupted 8.0.5 export into a Oracle 9i database. I get a IMP-00037 Character marker set unknown. MetaLink says it may be corrupted. It is not so anyone have any other suggestions? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: invalid object after imp

Dear DBAs I exp/imp whole OFA database and there are some invalid package bodies left on newly imported db. When I recompile it I got message insufficient privilege to access object SYS.DBMS_LOCK I check dba_sys_priv and both exp and imp databases are the same for those package bodies owner

Full IMP hangs at the same spot

Title: Full IMP hangs at the same spot We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a full exp/imp into a clone database. The imp hangs at the same location every time, on a table that has only 2 rows in it, although the table does have 2 VARCHAR2(2000) columns. We're unable

RE: Full IMP hangs at the same spot

Title: Full IMP hangs at the same spot truss, strace whatever. v$session_wait the usual -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, September 07, 2001 11:46 AMTo: Multiple recipients of list ORACLE-LSubject: Full IMP hangs at the same

Re: Full IMP hangs at the same spot

Did you run out of room in the target database? Rutg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 07, 2001 11:45 AM We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a full exp/imp into a clone database

RE: Full IMP hangs at the same spot

reet North, Chelmsford 01863 -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 11:46 AMTo: Multiple recipients of list ORACLE-LSubject: Full IMP hangs at the same spot We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do

Solved: IMP-00069 error when importing 8.1.7 export

Hi list, I got the export made with exp V8.1.6 and succesfully imported it with imp V8.1.7 to oracle 8.1.5 database. A lot of versiosn to use. Thanks to all who replied Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Schoen Volker

IMP-00069 error when importing 8.1.7 export

Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED]

Re: IMP-00069 error when importing 8.1.7 export

Hi, can you export your 81700 db with the 81701 exp utility? oli [EMAIL PROTECTED] wrote: Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and

IMP 8.1.6 to 8.1.7 DB

I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you

Re: IMP 8.1.6 to 8.1.7 DB

Subject: IMP 8.1.6 to 8.1.7 DB I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you

Re: IMP 8.1.6 to 8.1.7 DB

Thank you Sharma, Lunch is in my mind :) - Original Message - From: Saurabh Sharma To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 11:40 AM Subject: Re: IMP 8.1.6 to 8.1.7 DB wanna get my lunch first , then i must say u ..YES

RE: IMP 8.1.6 to 8.1.7 DB

recipients of list ORACLE-LSubject: Re: IMP 8.1.6 to 8.1.7 DB wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple

RE: IMP 8.1.6 to 8.1.7 DB

AM To: Multiple recipients of list ORACLE-L Subject: Re: IMP 8.1.6 to 8.1.7 DB wanna get my lunch first , then i must say u ..YES. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz

imp use/pas file=blah.dmp log=blah.dmp...

Here is a fun one for you. If you set the log file to the dump file on you import it will of course wipe out your dump file. However, Oracle is nice enough to go ahead and tell you *after* it wipes out your dump file that setting your log file to your dump file is an invalid option! I

Re: imp use/pas file=blah.dmp log=blah.dmp...

Ethan, you wanted them to tell you BEFORE it wiped it out?, thats in oracle 10i :) joe [EMAIL PROTECTED] 07/30/01 01:00PM Here is a fun one for you. If you set the log file to the dump file on youimport it will of course wipe out your dump file. However, Oracle is niceenough to go ahead

RE: imp use/pas file=blah.dmp log=blah.dmp...

Actually some version do tell you before, I believe all the Win32 tools do. I know I have seen a message stating the log and file cannot be the same and it aborted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA

Imp problem

hi, I have an export with WE8DEC, and i want do a full import on a database With WE8ISO8859P1 character set. But avery time i do it a have a problem when he want to create indexes with: ORA-01115: erreur E/S en lecture de blocs a partir du fic. 9 (bloc # 13) ORA-01110: fichier de donnJes 9:

RE: Exp/Imp - suppress screen output?

recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA

RE: Exp/Imp - suppress screen output?

run the script in background export.sh import.sh -Original Message- Sent: 20 July 2001 14:15 To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w

RE: Exp/Imp - suppress screen output?

Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20,

RE: Exp/Imp - suppress screen output?

/Imp - suppress screen output? Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http

RE: Exp/Imp - suppress screen output?

1 is standard output 2 is standard error -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Exp/Imp - suppress screen output? Why 1 /dev/null 2dev/null and not just

Re: Exp/Imp - suppress screen output?

You can code it like this: exp / tables=mike mike.log 21 output is in mike.log -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Exp/Imp - suppress screen output?

Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20,

Re: Exp/Imp - suppress screen output?

Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED]

RE: Exp/Imp - suppress screen output?

of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy

RE: Exp/Imp - suppress screen output?

is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null

Re: Importing indexes with INDEXFILE in imp

On Wednesday 11 July 2001 09:11, Jesse, Rich wrote: The problem I'm having is that the generated file contains CONNECT schema commands for every schema that has an indexed table. Does everybody just gather up all the passwords to all the schemas and manually Rich, Use a script to change

Importing indexes with INDEXFILE in imp

sizes (20GB for us) is that it is much faster to use the INDEXFILE option of imp, then run it's generated script after the rest of the DB objects have been imp'd. The problem I'm having is that the generated file contains CONNECT schema commands for every schema that has an indexed table. Does

How do IMP EXP - SOS

Title: How do IMP EXP - SOS hi I need to do the IMP of a dmp file from Oracle 8i to 8.1.5 can you guys pls help me how to go about it with warm regards deewaker g v

RE: How do IMP EXP - SOS

Title: How do IMP & EXP - SOS Deewaker, You did not mention what is the version of Oracle 8i. I am assuming it is higher than Oracle 815. In this case do the following steps. 1. Take export of the schema using exp from Oracle 815. To do this , you can connect to your source data

RE: How do IMP EXP - SOS

Title: How do IMP & EXP - SOS technet.oracle.com should give you everything you need under documentation. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From

imp-00002: échc d'ouverture de k:\ora

: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production IMP-2: échec d'ouverture de K:\oramaj\exp12_05.dmp pour lecture Fichier d'import : EXPDAT.DMP ps : RDBMS Version: 8.1.6 Operating System and Version: Windows 2000

<    1   2   3   >