Home » RDBMS Server » Server Utilities » Importing Dump From Higher Database Version 2 Lower. (9i,10g,11g.)
icon5.gif  Importing Dump From Higher Database Version 2 Lower. [message #469104] Tue, 03 August 2010 06:17 Go to next message
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.

Re: Importing Dump From Higher Database Version 2 Lower. [message #469107 is a reply to message #469104] Tue, 03 August 2010 06:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469108 is a reply to message #469107] Tue, 03 August 2010 06:29 Go to previous messageGo to next message
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469109 is a reply to message #469108] Tue, 03 August 2010 06:31 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Correct.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469115 is a reply to message #469109] Tue, 03 August 2010 07:00 Go to previous messageGo to next message
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 3610 times)
Re: Importing Dump From Higher Database Version 2 Lower. [message #469116 is a reply to message #469115] Tue, 03 August 2010 07:01 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
No idea.
Can you create that function in the db?
Re: Importing Dump From Higher Database Version 2 Lower. [message #469130 is a reply to message #469116] Tue, 03 August 2010 07:53 Go to previous messageGo to next message
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
Re: Importing Dump From Higher Database Version 2 Lower. [message #469133 is a reply to message #469130] Tue, 03 August 2010 08:10 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469136 is a reply to message #469133] Tue, 03 August 2010 08:23 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thankx
Re: Importing Dump From Higher Database Version 2 Lower. [message #469149 is a reply to message #469107] Tue, 03 August 2010 09:39 Go to previous messageGo to next message
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 ?
Re: Importing Dump From Higher Database Version 2 Lower. [message #469152 is a reply to message #469149] Tue, 03 August 2010 09:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>is This regards to imp/exp utility ?
Yes.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469154 is a reply to message #469130] Tue, 03 August 2010 10:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469194 is a reply to message #469154] Tue, 03 August 2010 14:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469215 is a reply to message #469152] Tue, 03 August 2010 23:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
So how About from imp/exp from 11G to 9i
Re: Importing Dump From Higher Database Version 2 Lower. [message #469256 is a reply to message #469215] Wed, 04 August 2010 01:46 Go to previous messageGo to next message
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





Re: Importing Dump From Higher Database Version 2 Lower. [message #469290 is a reply to message #469256] Wed, 04 August 2010 02:37 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469360 is a reply to message #469215] Wed, 04 August 2010 06:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469373 is a reply to message #469367] Wed, 04 August 2010 06:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Ok Smile.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469379 is a reply to message #469377] Wed, 04 August 2010 06:40 Go to previous messageGo to next message
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 3138 times)
Re: Importing Dump From Higher Database Version 2 Lower. [message #469380 is a reply to message #469379] Wed, 04 August 2010 06:42 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
can you please if it is in Path ?
Re: Importing Dump From Higher Database Version 2 Lower. [message #469381 is a reply to message #469379] Wed, 04 August 2010 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is expdp not expdb.
Re: Importing Dump From Higher Database Version 2 Lower. [message #469412 is a reply to message #469381] Wed, 04 August 2010 09:19 Go to previous messageGo to next message
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.

Re: Importing Dump From Higher Database Version 2 Lower. [message #469415 is a reply to message #469412] Wed, 04 August 2010 09:27 Go to previous messageGo to next message
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!
Re: Importing Dump From Higher Database Version 2 Lower. [message #469456 is a reply to message #469412] Wed, 04 August 2010 12:56 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Import from 64bit to 32bit
Next Topic: how to handle null values in sql loader
Goto Forum:
  


Current Time: Thu Mar 28 19:06:51 CDT 2024