Re: import problem - newbie question

LeRoy, Even though you start your import as system, when the process starts to import tables owned by (for example) 'appuser' it will switch to that user. What I'm thinking is that you should create the user in advance of starting the import and give the user adequate tablespace quota. I may be

Import Problem

I ran into a problem yesterday afternoon. I had exported a production database, via a full database export, and ftp'd it to another machine to import it there and make that the new production machine. It was a long import (about 8 hours) and about 2/3 through it, my network connection was

Re: Import Problem

now you know why I script everything and run it as a background job on the database server itself. :) That I know of, there is no way to restart an import... unless you have primary key or unique constraints on all objects and you are will to do ignore=y so that you get constraint errors on

RE: Import Problem

There might be specific cases where you can, depending on constraints, etc., but in general, I don't think so. Two approaches to keep it from being interrupted: 1. sh -c nohup imp option1=xxx option2=xxx etc 2. echo imp option1=xxx option2=xxx | at now You might want to add some output

Re: Import Problem

Canaan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/03/2003 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Import Problem I ran into a problem yesterday afternoon. I had exported

Re: Import Problem

://www.gnu.org/directory/GNU/screen.html HTH Jared Scott Canaan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/03/2003 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Import Problem I ran

Re: Import Problem

: [EMAIL PROTECTED] Subject: Re: Import Problem

RE: Import Problem

For GUI, you can use VNC. Or screen utility. Both are freely avaible. Or script it and nohup the job on Unix. Richard Ji -Original Message- Sent: Monday, March 03, 2003 9:09 AM To: Multiple recipients of list ORACLE-L I ran into a problem yesterday afternoon. I had exported a

Re: Serious import problem (help!)

Error: ORA 3125 Text: client-server protocol violation --- Cause: The application received a bad escape sequence from the server which may indicate a problem with the client application user code. Action:

Serious import problem (help!)

Title: Serious import problem (help!) Folks, I've been exporting data from the production db's every night for over a year. We use these exports to import into the test db's that we have setup in the office. Well, starting yesterday I am no longer able to import successfully into any of our

Import Problem

I have created the .bmp file for import to my DB. All I want to do is import that data. Here is the imp script: file=h:\kjanusz\sqlldr\log\nic13.dmp log=h:\kjanusz\sqlldr\log\nic13imp.log commit=N ignore=Y analyze=N indexes=N constraints=N grants=N rows=Y destroy=N tables=(*) And here is

Re: Import Problem

Hi Ken, At first blush it doesn't look like the user kenneth owns any objects, Were there particular users that owned the objects before? If you want everything imported you could add full=yes and remove the tables=* from your imp.dat. Hope this helps, John [EMAIL PROTECTED] wrote: I have

Re: Import Problem

Remove tables=(*) from your parfile or list all tables like tables=tableA,tableb etc... Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 31 Dec 2001 12:45:18 -0800 I have created the .bmp file for import to my DB. All I want to do is import

import problem

hi list, I have a problem when I try to do import, sometimes the tables that have p.k. using index are created only with the index and not with the p.k. Do you have any suggestion? thanks in advance Alon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Ben-Zvi

Import Problem

Hi I saw this over on the Sun System admin list and was interested in the cause of it. My suspicion is that it has something to do with 2GB files limits Oracle data base using the imp command on my Solaris 2.6 server this is the message that I receive Import: Release 8.1.5.0.0 - Production on

Re: imp (import) problem

extend the tablespace by adding a datafile to the tablespace. -- On Fri, 09 Mar 2001 07:40:41 Leyden, Joseph wrote: While importing a huge table (AIX) I get this problem: and the progam seems to hang up. Help! I'm still new to ORACLE databases. IMP-3: ORACLE error 1658 encountered

imp (import) problem

While importing a huge table (AIX) I get this problem: and the progam seems to hang up. Help! I'm still new to ORACLE databases. IMP-3: ORACLE error 1658 encountered ORA-01658: unable to create INITIAL extent for segment in tablespace DAILYCYCLE01A TIA Joe -- Please see the official

Re: imp (import) problem

Joe, There is not enough contigius free space in the tablespace DAILYCYCLE01A for the import to create the segment you are importing. Check the size of the segment on the original database and make sure you have the space available on the import server. You can always increate the size of the