Hi guys,
Thank You
Durinda.Jones
Don.Jerman
Dave Weber
Gillies Garry
Raghu Kota
Ruth Gramolini
Mohan, Ross
And to all readers..
What I am doing now is to try write my own backup script and test it in my
stand alone Sun Ultra 10
with Solaris 2.7 and Oracle 8.1.6
Thank you guys, for giving me
Hi,
Just some thoughts - at step 7 did teddy commit after the delete - if not
other users / sessions would still see the records as present.
The import found some records so their must be an emp somewhere.
So, try another step from your dba account (sun) of
select object_name,
I believe the SHOW=Y parameter is causing the problem. That does not do an
import but rather lists the table/index/grants etc details held on the
export.dmp
REmove that parameter and try the fromuser to user parameters or the full =y
parameter
John
-Original Message-
[EMAIL PROTECTED]
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists,
so you need to ignore errors, otherwise it won't import the rows. SHOW=Y
will only list the contents of the export file, so it needs to be set to N
(or not set it at all) so the rows will be imported.
I would use care
Title: RE: No record in import help me please :..(
take out
SHOW=Y
it does just that: only SHOWs what it would do, does NOT do it.
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 9:45 AM
To: Multiple recipients of list
You need to add
FROMUSER=TEDDY
TOUSER=TEDDY
to your parameter file and try again.
[EMAIL PROTECTED] wrote:
Hi guys,
1. In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
2. I run the catexp.sql using
Use the TABLES=(teddy.emp) and FROMUSER=teddy, TOUSER=sun parameters in you
import parfile. This should do it.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 9:45 AM
Hi guys,
1. In my Oracle I have accounts : -
ot; [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: No record in import help me please :..(
Date: Mon, 05 Mar 2001 08:10:21 -0800
I believe the SHOW=Y parameter is causing the problem. That does not do an
import but rather lists
When you use show=y, you're just listing the tables in the dump file.
Either set this to N, or leave it out of your parm file. (N is the default)
imp help=y will also tell you this.
Hope that helps
Patrick Prince
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists,
so you need to ignore errors, otherwise it won't import the rows. SHOW=Y
will only list the contents of the export file, so it needs to be set to N
(or not set it at all) so the rows will be imported. Use the
Try using FROMUSER/TOUSER when importing.
HTP.
Gunawan Yuwono
--- [EMAIL PROTECTED] wrote:
Hi guys,
1. In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
2. I run the catexp.sql using sys account (just
11 matches
Mail list logo