Farnsworth, Dave wrote:
>
> Arun,
>
> Thanks for the suggestion. I am doing export/import because I do not know
> how to ship a database to another server. For that matter, I am doing
> export/import for the first time. I figured that since our DB is not a 24X7
> tha
rnsworth, Dave" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Export/Import question
>Date: Wed, 05 Sep 2001 03:20:56 -0800
>
>Thanks Tom and others that replied,
>
>That was the exp
Arun,
Thanks for the suggestion. I am doing export/import because I do not know
how to ship a database to another server. For that matter, I am doing
export/import for the first time. I figured that since our DB is not a 24X7
that I could get a clean export. I guess I have to get my hands
about how the export/import utility works. My situation
is that damagement had me put my live and test environments on the same
server. Now they realize that this is not a good situation(test has crashed
the server a few times and required a re-boot, imagine that). I have Oracle
8.1.7 running on
options.So it is
not bothered
about the PHYSICAL locations of data files.
hth,
Suren
-Original Message-
Sent: Tuesday, September 04, 2001 4:02 PM
To: Multiple recipients of list ORACLE-L
I have a question about how the export/import utility works. My situation
is that damagement had me put
aver: http://www.ud.com
Use spare CPU to assist in cancer research.
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 04 September 2001 20:24
|I have a question about how the export/import utility works. My
situation
|is that damagement had me put
move my live database to another
server. From reading the fine manuals and from posts that I have seen I
have decided to use the export/import utility to make my move. My database
is inactive for the weekend. What I am not sure of is this, on my current
live database my datafiles(.dbf) reside on
Create all tablespaces(same name as in the source database) before you
import.
-Original Message-
Dave
Sent: Tuesday, September 04, 2001 4:02 PM
To: Multiple recipients of list ORACLE-L
I have a question about how the export/import utility works. My situation
is that damagement had
ACLE-L
I have a question about how the export/import utility works. My situation
is that damagement had me put my live and test environments on the same
server. Now they realize that this is not a good situation(test has crashed
the server a few times and required a re-boot, imagine that). I h
I have a question about how the export/import utility works. My situation
is that damagement had me put my live and test environments on the same
server. Now they realize that this is not a good situation(test has crashed
the server a few times and required a re-boot, imagine that). I have
Thanks for the info. I looked at it, it's very informative.
>>> [EMAIL PROTECTED] 07/22/01 12:17PM >>>
Richard,
This is an issue with TYPE objects as the TOID (type
object ID) is exported (see the Utilities manual).
Also see Note: 1066139.6 "IMP-17 IMP-3 ORA-2304 IMP-63
FROMUSER/TOUSER Import
Richard,
This is an issue with TYPE objects as the TOID (type
object ID) is exported (see the Utilities manual).
Also see Note: 1066139.6 "IMP-17 IMP-3 ORA-2304 IMP-63
FROMUSER/TOUSER Import of Table With Object Column"
HTH,
-- Anita
--- Richard Ji <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I
Kevin,
Thanks for letting me know that I am not the only one had to
go throught this. :) Thank God I have VI editor, can't imagine
if I had to use notepad on windows to edit that file. There are
106 types!
Richard Ji
>>> [EMAIL PROTECTED] 07/11/01 01:15PM >>>
I've experienced and must admit t
I've experienced and must admit that it is a pain in the arse to deal with:)
KK
-Original Message-
Sent: Wednesday, July 11, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I wonder if anyone has seen this before.
I export an user A, then import it into user B in a diff
Hi all,
I wonder if anyone has seen this before.
I export an user A, then import it into user B in a different database
and everything is ok. Then I use the same export file to import into
user C in the same database as user B and all the "CREATE TYPE"
failed because Oracle retains the obj
look at the script
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 6:45 PM
> Is it possible to Export and Import Users definition including password .
>
> Here we have a production schema where we have created users to acce
CTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: export / import users definition
>Date: Mon, 09 Jul 2001 07:45:25 -0800
>
>Is it possible to Export and Import Users definition including password .
>
>Here we hav
Is it possible to Export and Import Users definition including password .
Here we have a production schema where we have created users to access our
production objects . We are moving production database to another test
database
. Now we wants users definition and password also to be moved there
I run script in the background which contain export command. If userid wrong
it give me message that job stopped
(bash). Process is stopped and I can see it using ps command. Apparently it
waits that username be entered interactively. I need automatically to
terminate the process and print message
ACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 11:51 AM
> We need to allow a user to export/import a different user's objects.
> We want to limit access to the designated schema, so we're trying to
> avoid granting EXPORT/IMPORT_FULL_DATABASE. We don't wa
ed to allow a user to export/import a different user's objects.
We want to limit access to the designated schema, so we're trying to
avoid granting EXPORT/IMPORT_FULL_DATABASE. We don't want passwords
embedded within scripts either, for obvious reasons.
Is there any way to do t
We need to allow a user to export/import a different user's objects.
We want to limit access to the designated schema, so we're trying to
avoid granting EXPORT/IMPORT_FULL_DATABASE. We don't want passwords
embedded within scripts either, for obvious reasons.
Is there any
Title: RE: Build an exact copy of a database using export / import
Let me
rephrase that first sentence... A full export is supposed to allow you to
recreate your base entirely at the point of export. A bit different from a
"full recovery" which means all transactions to th
his works pretty well but I miss some of the grants and The full import
wants to create tablespaces that I may or may not want created. I get a lot
of errors on system objects. Does anyone have the proper steps to create an
exact copy of a production database using export / import?
Thanks!
Ron
pients of list ORACLE-L
We use "Clones" of databases all the time. Its much faster than the
Export/import run. We simply take the DB down, copy the data files to a
new server in the same file layouts (i.e. ... same directory tree), copy
over and change the init file for the new DB na
gt; wants to create tablespaces that I may or may not want created. I get a lot
> of errors on system objects. Does anyone have the proper steps to create an
> exact copy of a production database using export / import?
Not what you asked, but I do this all the time with a warm backu
Title: RE: Build an exact copy of a database using export / import
A full export is supposed to allow for a full recovery. Thus, if you do a full export, the import will try to create all the tablespaces that existed when you exported. That is the first item in the export file (see below
We use "Clones" of databases all the time. Its much faster than the
Export/import run. We simply take the DB down, copy the data files to a
new server in the same file layouts (i.e. ... same directory tree), copy
over and change the init file for the new DB name, and bring it up.
Yes..Cloning is bit mature than export and import.
BTW you don't need to have the same directoty tree in
the target database. You can have a differenet
directory tree ..(you can edit the control file script
and it is done..)
=
Have a nice day !!
-
ces that I may or may not want created. I get a lot
of errors on system objects. Does anyone have the proper steps to create an
exact copy of a production database using export / import?
Thanks!
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http:/
errors on system objects. Does anyone have the proper steps to create an
exact copy of a production database using export / import?
Thanks!
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL
Hi!
I'm having weird problems with exporting/importing tables...
First I run an export on database A
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > tbclocktimes
. . exporting table TBCLOCKTIMES 29
Maybe there are several things you want to check on your table in database
B
1) Do you have any trigger on that table?
2) Do you have any foreign key constraints on that table?
3) Is that table structure the same on 2 databases?
Winnie
"Helmut Daiminger" <[EMAIL PROTECTED]> on 03/28/2001 11
vers? Do I just
> move the expdat.dmp (exported output) from
> AIX to NT and simply use the export/import
> utilities?
>
> TIA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leyden, Joseph
> INET: [EMAIL PROTECTED]
>
> Fat
: Multiple recipients of list ORACLE-L
Sent: 03/07/2001 5:31 PM
Can I import a database from NT which was
exported from AIX RS6000 servers? Do I just
move the expdat.dmp (exported output) from
AIX to NT and simply use the export/import
utilities?
TIA
--
Please see the official ORACLE-L FAQ: http
just move the expdat.dmp using a ftp binary data transfer and and use the
imp utility.
-Mandar
> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 4:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export/imp
Title: RE: export/import
> -Original Message-
> From: Leyden, Joseph [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 7. mars 2001 14:32
>
> Can I import a database from NT which was
> exported from AIX RS6000 servers? Do I just
> move the expdat.dmp (exported out
Can I import a database from NT which was
exported from AIX RS6000 servers? Do I just
move the expdat.dmp (exported output) from
AIX to NT and simply use the export/import
utilities?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL
Title: export / import 8.1.5 to 8.0 ?
Hi all -
Is it possible to export an 8.1.5 database and import it into an 8.0.x database? Does the compatibility or anything else special need to be set in order to make this happen?
Thanks -
Lisa
101 - 139 of 139 matches
Mail list logo