Mark Forums Read

9iR2 exp -> 10g imp

Go Back

comp.databases.oracle.server comp.databases.oracle.server

Reply

Page 1 of 15

1

#1

Old

jeremy

Posts: n/a

9iR2 exp -> 10g imp - 06-05-2008 , 04:00 PM

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks
--
jeremy

Reply With Quote

#2

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#3

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#4

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#5

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#6

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#7

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#8

Old

sybrandb@hccnet.nl

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-05-2008 , 05:06 PM

On Thu, 5 Jun 2008 14:00:41 -0700 (PDT), jeremy <jeremy0505 (AT) gmail (DOT) com>
wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks

Full=yes should work.

--
Sybrand Bakker
Senior Oracle DBA

Reply With Quote

#9

Old

Noons

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-06-2008 , 01:25 AM

On Jun 6, 7:00 am, jeremy <jeremy0... (AT) gmail (DOT) com> wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks
--
jeremy

might be a good idea to use also destroy=n...

Reply With Quote

#10

Old

Noons

Posts: n/a

Re: 9iR2 exp -> 10g imp - 06-06-2008 , 01:25 AM

On Jun 6, 7:00 am, jeremy <jeremy0... (AT) gmail (DOT) com> wrote:

Quote:

Hi quick question

We have a 9iR2 db on Solaris and another server is running 10gR2 on
RHEL4. We want to import the 9i db into 10g.

Exported from 9i using FULL=YES as a DBA user.

Can we import this into 10g with FULL=YES or should we import on a
schema by schema basis?

thanks
--
jeremy

might be a good idea to use also destroy=n...

Reply With Quote

Reply

Page 1 of 15

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.