OraFAQ Forum: Server Utilities » Importing Dump From Higher Database Version 2 Lower.

Home » RDBMS Server » Server Utilities » Importing Dump From Higher Database Version 2 Lower. (9i,10g,11g.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Importing Dump From Higher Database Version 2 Lower. [message #469104]

Tue, 03 August 2010 06:17

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear DBA Experts,

Any body let me know we can Import dump from higher database version to lower database version.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469107 is a reply to message #469104]

Tue, 03 August 2010 06:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Use the lower version to export from higher version
and
use the same lower version of imp to import into lower version.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469108 is a reply to message #469107]

Tue, 03 August 2010 06:29

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Quote:

use the same lower version of imp to import into lower version.

Its means we can't import 11g dump into 10g databse version.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469109 is a reply to message #469108]

Tue, 03 August 2010 06:31

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Correct.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469115 is a reply to message #469109]

Tue, 03 August 2010 07:00

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Thanks for prompt reply.

Dear you are right but Today when I was trying to Import dump 11g to
Oracle Database 10g Express Edition,data is imported and only forms & report showing compilation error .

Error 0 at line 3 column 1
SQL Statement ignored

Kinldy see below image.

/forum/fa/8125/0/

why it happened Please explain ?

Attachment: Error.JPG
(Size: 41.27KB, Downloaded 4053 times)

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469116 is a reply to message #469115]

Tue, 03 August 2010 07:01

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

No idea.
Can you create that function in the db?

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469130 is a reply to message #469116]

Tue, 03 August 2010 07:53

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Cookiemonster,

I created that function in the db level successfully created.
But when we used any DML in Forms & Reports then showing this error.

Error 0 at line 3 column 1
SQL Statement ignored

Thanks & Regards,

Irfan

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469133 is a reply to message #469130]

Tue, 03 August 2010 08:10

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Are you using the same DB login in form builder that you used to create the function in the DB?
If yes then I suggest you retry the import using the 10g export utility like Mahesh told you to.
If that still doesn't work then your best bet would be to raise the issue with oracle support.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469136 is a reply to message #469133]

Tue, 03 August 2010 08:23

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Thankx

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469149 is a reply to message #469107]

Tue, 03 August 2010 09:39

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Mahesh Rajendran wrote on Tue, 03 August 2010 06:23

Use the lower version to export from higher version
and
use the same lower version of imp to import into lower version.

Mahesh Me confused ..is This regards to imp/exp utility ?

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469152 is a reply to message #469149]

Tue, 03 August 2010 09:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>is This regards to imp/exp utility ?
Yes.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469154 is a reply to message #469130]

Tue, 03 August 2010 10:03

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

All Exp/Imp does is get the metadata/data and recreate in target.
And you did it manually and it compiled. Right?
>>But when we used any DML in Forms & Reports then showing this error.
Methinks, this is something else to do with your Forms/report environment.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469194 is a reply to message #469154]

Tue, 03 August 2010 14:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What Forms version do you use?

Did you try to recompile all (Ctrl + Shift + K)?

What happens if you rewrite the function code (this line only):

function a_name (accid IN number) return char is
...

What is GL_NATURAL_ACCT table's description? I'm interested particularly in LATIN_DESC and GL_NATURAL_ACCT_ID columns.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469215 is a reply to message #469152]

Tue, 03 August 2010 23:29

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Mahesh Rajendran wrote on Tue, 03 August 2010 09:57

>>is This regards to imp/exp utility ?
Yes.

If I am not mistaken ..Even I use lower version to export from Higher Version of Oracle DB then Newly introduced Data Type might not be Supported By Same.

For Ex. BINARY_DOUBLE Etc..

(Edit Spell Check.)

[Updated on: Tue, 03 August 2010 23:30]

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469216 is a reply to message #469215]

Tue, 03 August 2010 23:36

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

So how About from imp/exp from 11G to 9i

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469256 is a reply to message #469215]

Wed, 04 August 2010 01:46

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Littlefoot,

Quote:

What Forms version do you use?

Forms [32 Bit] Version 11.1.1.3.0.

Quote:

Did you try to recompile all (Ctrl + Shift + K)?

Yes,Same error

Error 0 at line 3 column 1
SQL Statement ignored

Quote:

What happens if you rewrite the function code (this line only)

function a_name (accid IN number) return char is
...

Same error.

Quote:

What is GL_NATURAL_ACCT table's description? I'm interested particularly in LATIN_DESC and GL_NATURAL_ACCT_ID columns.


DESC GL_NATURAL_ACCT
Name                           Null     Type                                                                                                                                                                                          
------------------------------ -------- -------------------------
GL_NATURAL_ACCT_ID             NOT NULL NUMBER                                                                                                                                                                                        
NATURAL_ACCT_CODE              NOT NULL VARCHAR2(15)                                                                                                                                                                                  
LATIN_DESC                     NOT NULL VARCHAR2(60)                                                                                                                                                                                  
ARABIC_DESC                    NOT NULL VARCHAR2(60)                                                                                                                                                                                  
PARENT_ID                               NUMBER                                                                                                                                                                                        
TYPE                           NOT NULL VARCHAR2(1)                                                                                                                                                                                   
IS_BLOCKED                     NOT NULL VARCHAR2(1)                                                                                                                                                                                   
GL_CONTEXT_TYPE_ID                      NUMBER                                                                                                                                                                                        
IS_CUSTOMER_ACCT               NOT NULL VARCHAR2(1)                                                                                                                                                                                   
IS_SUPPLIER_ACCT               NOT NULL VARCHAR2(1)                                                                                                                                                                                   
GL_COMPANY_ID                  NOT NULL NUMBER                                                                                                                                                                                        
CREATED_BY                     NOT NULL VARCHAR2(60)                                                                                                                                                                                  
CREATED_DATE                   NOT NULL TIMESTAMP(6)                                                                                                                                                                                  
UPDATED_BY                     NOT NULL VARCHAR2(60)                                                                                                                                                                                  
UPDATED_DATE                   NOT NULL TIMESTAMP(6)                                                                                                                                                                                  
CONTEXT_TYPE                            VARCHAR2(1)

Regards,

Irfan

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469290 is a reply to message #469256]

Wed, 04 August 2010 02:37

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't see anything unusual here; unfortunately, none of my ideas was useful. Sorry.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469360 is a reply to message #469215]

Wed, 04 August 2010 06:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> Even I use lower version to export from Higher Version of Oracle DB then Newly introduced Data Type might not be Supported By Same.

Export/import is always meant to be used for moving data around.
Not for upgrade.
If one still still chooses to, there are specific scripts /stages to be used ( in case of compatibility issues). Check the good old document on export/import compatibility matrix.
Use the lower version to export and use the target version to import.

[Updated on: Wed, 04 August 2010 06:18]

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469367 is a reply to message #469360]

Wed, 04 August 2010 06:25

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Mahesh BINARY_DOUBLE in higher version is not Supported by EMP/IMP we need Data Pump (empdb/impdb) for this and this is not available in lower versions.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469373 is a reply to message #469367]

Wed, 04 August 2010 06:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Mahesh BINARY_DOUBLE in higher version is not Supported by EMP/IMP we need Data Pump (empdb/impdb) for this and this is not available in lower versions.

Did I every say no?
Did you even read my previous post?

Quote:

If one still still chooses to, there are specific scripts /stages to be used ( in case of compatibility issues). Check the good old document on export/import compatibility matrix.

[Updated on: Wed, 04 August 2010 06:33]

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469377 is a reply to message #469373]

Wed, 04 August 2010 06:34

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469379 is a reply to message #469377]

Wed, 04 August 2010 06:40

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Mahesh,
Kindly see.

/forum/fa/8130/0/

when I m trying to write expdb on 11g Database version then error why.

Please explain .

Regards,

Irfan

Attachment: expdb.JPG
(Size: 15.61KB, Downloaded 3572 times)

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469380 is a reply to message #469379]

Wed, 04 August 2010 06:42

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

can you please if it is in Path ?

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469381 is a reply to message #469379]

Wed, 04 August 2010 06:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is expdp not expdb.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469412 is a reply to message #469381]

Wed, 04 August 2010 09:19

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Quote:

>>Mahesh BINARY_DOUBLE in higher version is not Supported by EMP/IMP we need Data Pump (empdb/impdb) for this and this is not available in lower versions.

I read Data Pump (empdb/impdb) and trying .. Sorry.

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469415 is a reply to message #469412]

Wed, 04 August 2010 09:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Step back from obsessing about specific utilities.
If/when an application implements an application using a feature like BINARY DOUBLE,
it implicitly acknowledges that this application will NEVER run on a lower version of Oracle where said feature does not exist!

Report message to a moderator

Re: Importing Dump From Higher Database Version 2 Lower. [message #469456 is a reply to message #469412]

Wed, 04 August 2010 12:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Sorry for what?
Are you using Binary_double? Else, no need to worry about it.
Your issue has nothing to do with this.
Not sure why this fuss about binary_double in this thread.

Report message to a moderator

Previous Topic:	Import from 64bit to 32bit
Next Topic:	how to handle null values in sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 14:30:03 CST 2024