ORACLE-L <[EMAIL PROTECTED]>
om> cc:
Sent by: S
ECTED]>To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
>
Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: 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, Ja
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 G
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 the
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
databas
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 ab
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 ex
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
Owners
are different. I am using fromuser touser.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of anuSent:
Wednesday, December 24, 2003 12:04 PMTo: Multiple recipients of
list ORACLE-LSubject: RE: Export/Import issue.
I think data will
I think data will never change like that. Are the owners the same. Or are you doing fromuser touser.
You can use the show option to see the contents of the export dump file. Then make sure all objects are dropped. [EMAIL PROTECTED] wrote:
I am 100% positive . I tried this process 2-3 times using di
I am 100% positive . I tried this process 2-3 times using different approach but same
output. I tried to create objects first using no data. I also tried to create objects
as part of loading data but no difference. I enabled 10046 trace for the import
process but that also didnt help, it showing
Avnish,
Are you absolutely sure that the target table is either gone before the
import, or empty? You should not be getting a unique constraint violation
if the table does not exists before import.
The step that Oracle import follows for importing is:
Create the table
import the data
create cons
I am trying to export a table from one database to another. Table in target database
is dropped before importing and is being created as part of import process. During
import process data Oracle is complaining Unique constraint violated and throwing out
following messages. Its complaining on i
]
Sent by: cc:
[EMAIL PROTECTED] Subject: [Q] export/import privileve
on Win NT?
ity.com
On ORACLE 8i, The user need import/export his schema.
I grant "EXP_FULL_database and IMP_FULL_database" to
this user. The user complaint he still need "Local
admin" right to do it under NT and Win 2000. Is it
true?
Thanks you for help.
__
Do you Yahoo!?
Yahoo
Good afternoon everyone,
I'd like to know if anyone out there is using the export/import method to copy data
from a LONG column to a CLOB column. I've been doing this for a number of months now,
but one the DBAs I spoke to thinks that this method is not supported and there may be
iss
exp help=yes
"Johnson; Michael " <[EMAIL PROTECTED]> wrote on 1/31/03 3:34 pm:
>From the O/S prompt
$EXP HELP=Y or
$IMP HELP=Y
or see the Utilities manual, I believe chapters 2 and 3.
Also, Kirti wrote up some good principles when using export and import that I
keep on file.
Im sure he could
Title: RE: Export / Import
exp -help
> -Original Message-
> From: Scott Stefick [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 31, 2003 3:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Export / Import
>
>
> Hello,
>
> OS Version:
>From the O/S prompt
$EXP HELP=Y or
$IMP HELP=Y
or see the Utilities manual, I believe chapters 2 and 3.
Also, Kirti wrote up some good principles when
using export and import that I keep on file.
Im sure he could help you if you request it.
HTH, Mike
-Original Message-
Sent: Frida
Never mind. After I posted, I found a good website that included all of
what I was looking for.
Just incase anyone else wants that kind of info, here is the link:
http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96652/part1.htm
Thanks,
-Scott
**
Hello,
OS Version: HP-UX 11i
DB Version: Oracle 8.1.7.4 and 9.2.0.1
I've been looking around and I cannot seem to find a difinitive guide
online about Oracle's Export and Import. I'm looking for all of the
parameters and what they do. Could anyone point me in the right direction.
Thanks,
-Sc
Tracy,
I hit the same bug when doing reorg using export/import (Solaris 2.6, Oracle 8.1.7.4)
for some tables in our baan erp database. The tables had unique constraints that were
failing after the import. Found out that import has changed the values in some unique
index columns. The export was
check
out note 199416.1 - talks about export corruption on certain
releases.>>> [EMAIL PROTECTED] 1/8/03 2:44:15 PM
>>>Tracy Rahmlow wrote:> > We attempted to reorg a
table and data corruption resulted. We have isolated> the issue and
currently have a tar open with Oracle. But basically, w
Tracy Rahmlow wrote:
>
> We attempted to reorg a table and data corruption resulted. We have isolated
> the issue and currently have a tar open with Oracle. But basically, when we
> export the table with a buffer=10485760 the import process corrupts the data.
> The row count matches, however som
Could you be hitting bug 2410612 : CONVENTIONAL EXPORT HAS WRONG DATA ON
IMPORT?
From: "Tracy Rahmlow" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Export/Import Error and Validation !!!
Date: Tue
Tracy,
Have a look at bug 2475331 / 2410612 RDBMS CONVENTIONAL EXPORT HAS WRONG DATA
ON IMPORT
This is listed as having happened in 8173. Bug has no details of why or who it might
affect.
1. Use direct=true and the problem would not reproduce
2. Set the buffer size 100 and the proble
We attempted to reorg a table and data corruption resulted. We have isolated
the issue and currently have a tar open with Oracle. But basically, when we
export the table with a buffer=10485760 the import process corrupts the data.
The row count matches, however some fields that initially were nul
a month ago on MS NT 4.0, I imported a 70 gig dump file in 9.5 hours. That
time includes creating the indexes.
I can't remember what the totall size used in the database...
config:
8.1.7.2.3
Win NT 4.0 Svc. Pack 6a
There's also a brand new EMC Symmetrix on the backend
- Original Message -
Hi,
That doesn't sound particularly healthy to me. Depends what you're running
on I guess. We have a nightly batch job which does an import on 8.1.7,
rather weedy 933MHz Intel, 50Mb SGA, 4 x SCSI disk Linux box. The dump
file is 4.0Gb which turns out to be about 6Gb data, 1Gb indexes. It
Bill - For other import tuning ideas, see
http://www.orafaq.com/faqiexp.htm
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 20, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L
Good day, all:
I'm looking for real-life best-
Bill"
dware.com> cc:
Sent by: Subject: best case scenarios for
Title: RE: best case scenarios for export/import
2 x (IBM p690, 16CPU, 16GB Ram, Oracle 9201), Export file from 8161 34GB. Import is 12 parallel streams (6 on each machines) with no constraints, custom parfiles (to import certain schema per stream only), buffer (either 8M and 16M), 12GB Undo
Good day, all:
I'm looking for real-life best-case scenarios for running import/export . .
. I've been playing with this for quite some time and would like to know how
"fast" I can really expect this to go, particularly for the import.
I'd be interested to hear others' experiences - how fast have
You need to set the credentials for the node. If you are doing an export
on the node, OEM must be able to log into the node. As good practice, you
should create a valid userid and password for each node listed by OEM. OEM
cannot run a job on a node without having a userid to log onto the node
w
If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 5:04 PM
> Come on folks...Help me, I am stuck
, November 06, 2002 10:04
AM
Subject: Help required: Enterprise
Manager Console -> Export/Import/Backup
Come on folks...Help me, I am stuck...I run Oracle
8.1.6 on Win 2k (Both standard ed.). I am trying to run theexport wizard
through the Enterprise Manager Console by doing
A couple of things come to mind...
1. Set credentials for the node ORATEST, usually the user you installed
oracle with on the node.
2. Set credentials for the database to be a user with DBA privileges,
possibly even create a specific user to act as the primary user that you
will do this and other
: Multiple recipients of list ORACLE-L
Export/Import/Backup
Come on folks...Help me, I am stuck...
I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global
Come on folks...Help me, I am stuck...
I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL) -> Data
Management -> Export ...
and it comes
"Oracle Database is Portable" means that it can be ported to any OS
platform. Take a full Export of the database and then use the imp utility of
Oracle to build the exact database what was there on the previous one.
If you want to import certain objects then you need to create the tablespace
wi
Hi
It is Possible to import from NT to Solaris. The table space name should be
the same otherwise build the table and then import by ignoring the errors.
Ayyappan.S
This communication contains information, which is con
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, April 16, 2002 9:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 8.0.5 to 8.1.7 - export/import
>
> Hi -
>
> I believe I can do this, but I would like some confirmation and or
> warnings,
> e
Hi -
I believe I can do this, but I would like some confirmation and or warnings,
etc. We are migrating an application from 8.0.5 on NT to 8.1.7 on Unix
(Solaris 2.6). I would like to do this by creating the 8.1.7 instance and
then importing the data. Is it possible to export from the NT data
Harvinder,
IMHO, you are using the wrong approach. FGAC is meant for row-level
security. In fact, DBMS_RLS (RLS = Row-Level Security) is the package that
supports FGAC.
It's a lot easier to use the TABLES parameter in your export and import
parameter files to control which tables are exported/
We are testing Fine-Grained Access Control to export the complete schema
excluding some tables.
This works well for export but during import it try to import all tables.
Is there any way we can restrict import of some tables using Fine-Grained
Access Control
.We are using function as specified in
Hi
I have done export and import of one schema.After import the database size
has increased and I checked the tablespace which are having LOB objects grow
just twice approximately.What could be reason?
Thx
Seema
_
Send and receive
> > Hello Dave
> >
> > I checked the docs.
> > It seems to me that destroy is associated with
> transport_tablespaces.
> > If you transport tablespaces destroy=y means overwrite old data
> files
> > with the same name.
> >
> > In regular import the @database se
think there is a fix to it.
Lee
-Original Message-
Sent: 07 February 2002 15:29
To: Multiple recipients of list ORACLE-L
I just did my first export/import and of course I got some errors at the
very end of my import log file. My problem is I don't have a clue as to
what the
cc:
Sent by: Subject: export/import errors
[EM
e recipients of list ORACLE-L
> Subject: export/import errors
>
> I just did my first export/import and of course I got some errors at the
> very end of my import log file. My problem is I don't have a clue as to
> what they are. Below is the last few lines of the impo
Quick look in Metalink would suggest that this is a bug, I would report this
to Oracle. I think there is a fix to it.
Lee
-Original Message-
Sent: 07 February 2002 15:29
To: Multiple recipients of list ORACLE-L
I just did my first export/import and of course I got some errors at the
I just did my first export/import and of course I got some errors at the very end of
my import log file. My problem is I don't have a clue as to what they are. Below is
the last few lines of the import log file
About to enable constraints...
. importing DIS's objects into DIS
.
dd to the
> > existing datafiles without replacing them. "
> >
> >
> >
> > --- àãø_éçéàì <[EMAIL PROTECTED]> wrote:
> > > Hello Dave
> > >
> > > I checked the docs.
> > > It seems to me that destroy is associated with
>
> > If you transport tablespaces destroy=y means overwrite old data
> files
> > with the same name.
> >
> > In regular import the @database set the target database.
> >
> > Yechiel Adar, Mehish Computer Services
> > [EMAIL PROTECTED]
> >
> > > -Ori
>
>
> --- àãø_éçéàì <[EMAIL PROTECTED]> wrote:
> > Hello Dave
> >
> > I checked the docs.
> > It seems to me that destroy is associated with
> transport_tablespaces.
> > If you transport tablespaces destroy=y means overwrite old data
> files
&g
dar, Mehish Computer Services
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent: Tue, February 05, 2002 6:10 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: export/import on the sam
arget database.
>
> Yechiel Adar, Mehish Computer Services
> [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> > Sent: Tue, February 05, 2002 4:21 PM
> > To: Multiple recipients of list ORACLE-L
> > Subj
create tablespace
during import.
Mea Culpa
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, February 05, 2002 6:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE
ave [SMTP:[EMAIL PROTECTED]]
> > Sent: Tue, February 05, 2002 4:21 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:export/import on the same server
> >
> > I have a question on the export/import utility. I have my
> live(PROD)
> > and te
TEST datafiles sit.
Regards,
Sergey
-Original Message-
Sent: Tuesday, February 05, 2002 9:21 AM
To: Multiple recipients of list ORACLE-L
Subject: export/import on the same server
I have a question on the export/import utility. I have my live(PROD)
and test(TEST) databases are o
AIL PROTECTED]>
Subject: Re: export/import on the same
server
Sent by:
root@f
PROTECTED]
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, February 05, 2002 4:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export/import on the same server
>
> I have a question on the export/import utility.
next best thing to do would be to drop and
recreate the TEST database, tablespaces/datafiles and all. Then use
IGNORE=Y and DESTROY=N and again MAKE SURE YOU ARE POINTING TO TEST
when you do the import.
--- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote:
> I have a question on the e
ing the Import section of the
fine manual but am a bit confused on the datafiles part of it when doing
a full export/import. Do I need to use the DESTROY=N parameter?
I am new to this utility but want to learn it. I am reading the manuals
and some other reading material but still am not clear on t
I have a question on the export/import utility. I have my live(PROD)
and test(TEST) databases are on the same server. These are basically
the same schemas except that the data in TEST is old and that the
datafiles for PROD are on I: drive and the datafiles for TEST are on E:
drive.
My question
: Multiple recipients of list ORACLE-LSubject:
RE: Export/Import Job
Exporting an individual schema within APPS (GL /PA
etc) is not recommended due to the number of constraints that cross schemas
(to fnd tables for instance).
So
changing the block size is essentially non Apps specific and
Exporting an individual schema within APPS (GL /PA etc)
is not recommended due to the number of constraints that cross schemas (to fnd
tables for instance).
So
changing the block size is essentially non Apps specific and is just a straight
export /import.
Depending on your hardware and plan
Nick,
Export/Import on an Oracle Apps database is not very well supported. It is
my understanding (from another list) that a bug (or is that a feature :)
currently exists. This may not be applicable in your situation. A loss of
Java objects has been reported. Keeping in mind that Quest may need
If anyone out there
has a good time estimate for the following export/import job I would appreciate
it. The goal is to change the DB_BLOCK_SIZE.
Application: Oracle
Apps 11i
Database Size:
100GB, actually only about 80GB is used space.
2 CPU HP L-Class
machine.
I just need a
Hi
If one of the tablespace in database is TRANSPORT TABLESPACE.I have full
export with consistent=y and full=y.
Can I full import the database?
If yes then what will happened with transport tablespace?
In case of crash can I restore full database with full export?
The assumption is we don't have
cc:
Sent by: Subject: RE: Execution time for
export/import vs. alter table move
[EMAIL PROTECTED]tablesp
you can tweak export import better i feel as "move"
does not give you too many options.
we recently did a export of ~60Gb that took us about
45 minutes to complete. This speed was mainly due to
hacking of parameters like buffer etc. however this
was on a high end sun box(not 10
don't have time to do a test on a very large
table.
Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/import table method versus
alter table move to a new tablespace method?
Thanks for any time quotes you can provide.
I am doing a cost justification for upgrading a data warehouse from 8.0.4
to 8.1.7.
I need to submit it today and don't have time to do a test on a very large
table.
Does anyone have anecdotal evidence or experience in the time difference
required to reorg a tablespace using the export/i
h we are gonna import that
dump file also have objects of system and sys already created then wats the
point in exporting their objects too.
for example we have two databases, 1 production and other dev,
we have almost 10 user schemas which we replicate from production db to
development db using e
Title: full db export/import
hi list,
i wonder wat actually full db export has benefits over user level export,
cuz full db export also makes the objects of user sys and system as part of the dump file
(if i am right) , but the target database in which we are gonna import that dump file
Chk the target database characterset.
--
On Wed, 17 Oct 2001 23:55:18
Sundar wrote:
>Hi All,
>
>I am trying to import an user from ORacle Ver 8.1.6 Running under Solaris and Oracle
>8.1.7 running under Windows NT. I want to export a user from Win Oracle to Solaris
>oracle and I am getting the
Hi All,
I am trying to import an user from ORacle Ver 8.1.6 Running under Solaris and Oracle
8.1.7 running under Windows NT. I want to export a user from Win Oracle to Solaris
oracle and I am getting the following error.
Please help how to go about doing this.
***ERROR**
hu Kumaran[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Thursday, October 04, 2001 6:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Export - Import from Oracle v8 to v731
>
> Hi christopher,
>
> How i can make my orace8
Title: RE: Export - Import from Oracle v8 to v731
There is a compatible parameter for the
init.ora file.
The parameter is probably already there,
just set for your current version as it is generally included by default.
"Do not criticize someone until you walked a
mile in
Title: RE: Export - Import from Oracle v8 to v731
Hi christopher,
How i can make my orace8 server compatible with v731... is i can set any init.ora parameter
or something different
Nirma,
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent
To: Multiple recipients of list ORACLE-L
@FuelSpot.comcc:
> Subject: RE: Export - Impo
Title: Export - Import from Oracle v8 to v731
You generally cannot export from a higher level database to a lower. Although you can probably change the
compatible option to 7.3.4 and do it that way (from what I hear, never tried
it).
"Do not criticize someone until you wal
Title: Export - Import from Oracle v8 to v731
Hi gurus,
i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax).
I successfully completed the export process:
c:\>exp80 parfile=c:\exp_par.dat
exp_par.dat
---
userid=msalah/msalah@q
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 PR
--
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
-
--
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
-
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 Hennema
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 Net
--
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
-
--
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
-
--
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
-
;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 L
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 tablesp
hange 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 -- Volu
ase 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
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
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 mach
1 - 100 of 139 matches
Mail list logo
