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
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
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
Scott,
Try using screen. It is a piece of software using virtual tty 's.
I began using it in 1994 to avoid just such problems.
It gives you some unique capabilities. Start a process from
one client, goto another client, detach and re-attach there.
eg. start a job at home in a terminal
FYI...
Even more useful than screen is vnc (www.tightvnc.com). It has some of
the same capabilities as screen, but it works like X-windows. Using VNC,
you can start an Oracle Installer session on your laptop, shut it down, go
home, and resume the session when you get where you are going. It is
:
[EMAIL PROTECTED] Subject: 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
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
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