Exp 10.2.0 To Imp 11.2.0 Version Database?

Aug 15, 2013

I have doubts on export

1.) If we have taken exp (traditional export)of schema�s on database version 10.2.0 then shall we imp(traditional export) on database version 11.2.0?

2.) If we have taken expdp of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?

3.) If we have taken exp(traditional export) of schema�s on database version 10.2.0 then shall we impdp on database version 11.2.0?

View 6 Replies


ADVERTISEMENT

Precompilers, OCI & OCCI :: PRO*C Compiler Version Versus Database Version

Oct 15, 2010

We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.

if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.

Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.

View 3 Replies View Related

Database Refresh In Different Version?

Aug 24, 2012

Oracle 11.2.0.1 and 11.2.0.3.

Can rman refresh database from 11.2.0.1 to 11.2.0.3?

In another words, my source database is 11.2.0.1, my target database is 11.2.0.3

I want to refresh target database from source database. Is it ok since version is different?

View 6 Replies View Related

Reports & Discoverer :: How To Run Version 10g Report In Builder 6i Version

Jun 3, 2010

I have a report of version 10g . I want to run this report in oracle reports 6i version.

View 1 Replies View Related

Upgrade :: Database 32bit From 10.2.0.1 To 10.2.0.4 Version

Jun 24, 2012

I am trying to upgrade the database 32bit from 10.2.0.1 to 10.2.0.4 version in Linux 32 bit . I faced the version incompatibility error during patch set installation and hence ran the patchset installation with -ignoresysprereqs option.

Now during the patchset installation i encountered the below error in in the install logfile.
**************************************
INFO: Start output from spawned process:
INFO:
--------------------------------------------------------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/bin/genclntsh
INFO: genclntsh: genclntsh: Could not locate /u01/app/oracle/product/10.2.0/network/admin/shrept.lst
INFO: make:
INFO: *** [client_sharedlib] Error 1
INFO:
INFO: End output from spawned process.
INFO:
--------------------------------------------------------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2012-06-24_11-45-11AM.log' for details.
Exception Severity: 1
***********************************************

Provide me the certified os and versions for oracle db 10gr2

View 2 Replies View Related

SQL & PL/SQL :: Check If A Particular Version Available In Earlier Version Of Oracle

Mar 30, 2012

I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?

View 4 Replies View Related

Enterprise Manager :: Database Version For 10g OMS Repository?

Feb 1, 2013

What database version is supported as a repository for 10g OMS?

View 5 Replies View Related

Server Administration :: Version-time In V$database?

Jun 21, 2011

what does mean VERSION_TIME column in V$DATABASE;i know that there is an other column which is called CREATED which indicates when the database has been created and i think it will never change,but, what about VERSION_TIME ? when does it change ?

View 6 Replies View Related

SQL & PL/SQL :: Version Of Java Supported By Oracle Database 11g And 10g

Feb 22, 2011

what version of java is supported by Oracle Database 10g and 11g. Actually i am writing a User Defined Function in Java and was asking this question to know which version of java i need to compile the source file before uploading the jar.

View 2 Replies View Related

Server Administration :: Database Version Change?

Feb 6, 2010

i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard

i need same tablespace,data's everything same as of now.

View 8 Replies View Related

Windows :: Oracle Database Compatible Version With Win 7

May 10, 2012

I have Windows 7 (System Type - 64-bit OPerating System & ACPI X64 PC Type) and want to install Oracle Database.

The compatible version with the above operating system and send me the direct link for downloading.

View 17 Replies View Related

11.2 Version Of Database Server - V$object Usage?

Nov 16, 2012

how many rows created (replaced ?) und stored in v$object_usage on each fact of index scan? I'm using 11.2 version of database server

View 7 Replies View Related

XE :: OracleXE Version 11g R2 Installation During Database Startup

Sep 24, 2012

I am new user using oracle XE. During the installing process, all see is Ok, but, when database is over startup process, the process NOT RESPONDING, and i don't know the cause.

My environment

Hardware: NOTEBOOK HP Genuine Inter (R) CPU
T2500 @ 2.00GHz
1.66 GHz, 2 GB of RAM
SO : Windows XP with services pack 3

Installation flow implement:

1. Download Oraclexe from oracle site
2. The installation & configuration process finish succeful, but when el flow are in startup point and i treat to login
the login step give me the next message:

ERROR:
ORA-01089: Immediate shutdown in progress - no operations are permitted
Process ID:0
sESSION id: 0 Serial number: 0

I Hope about 5 hours and the message is the same, while when i hope about 5 hours.

View 7 Replies View Related

SQL & PL/SQL :: Version Of Oracle And JDBC Running On A Remote Database?

Jul 28, 2013

How to know the version of Oracle and JDBC of remote databases that is accessing my database through DBLInk.

For example I have a database A , B database is using my database Through a dblink.Now I want to know the version of oracle and jdbc which working on B.

View 4 Replies View Related

Client Tools :: Error / Unsupported Oracle Database Version

Dec 8, 2011

when i am trying to connect to the database using sqldeveloper i am not able to connect to database. its giving me an error "Unsupported Oracle database version" but with plsql developer I am able to connecting.

View 8 Replies View Related

Moving From 32 Bit Linux To 64 Bit Windows Version On Database Standard Edition

Aug 16, 2013

when migrating from  32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of? 

View 2 Replies View Related

Server Administration :: Can Restore Database Password File In ASM For 11gR2 Version

Mar 28, 2012

Can we restore database password file in ASM for 11gR2 version.

View 4 Replies View Related

Server Utilities :: Importing Dump From Higher Database Version 2 Lower

Aug 3, 2010

We can Import dump from higher database version to lower database version.

View 26 Replies View Related

Recovery Manager (RMAN) :: 06429 - RCVCAT Database Not Compatible With Version?

Sep 7, 2012

I have four Oracle 8i databases that can not be removed because of client requirements. These 8i databases have there own RMAN catalog which is 10G (Originally there were Oracle 8i, 9i and 10g databases using it but are now moved to 11g catalog). Databases are backing up fine. However, all the other databases are using the RMAN 11g Catalog. I want to point the Oracle 8i databases to point to the RMAN 11g recovery catalog. I created an 8i schema, however, i'm getting the following error message: RMAN-06429: RCVCAT database is not compatible with this version of RMAN. however, I wanted to put the question out there to see if there are any work arounds.

View 3 Replies View Related

Application Express :: How To Change Language Of Version (integrated With Oracle Database 11g XE)

Apr 4, 2013

I downloaded Oracle Database 11g Express Edition R2 to test Apex (I've never used). I want to know how to change the language of the version of Apex (integrated with Oracle Database 11g XE)? I would apex in French.

View 7 Replies View Related

Application Express :: Current Version Of Data In Database Has Changed Since User Initiated Update

Sep 25, 2012

I am experimenting with the 4.2 version of Apex at URL.....

I have created a tabular form (based on a view with an instead of trigger) and have restricted this form to "Update only" mode. Whenever I modify a field value and submit the change I get the error "Current version of data in database has changed since user initiated update process".

View 6 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Version Of PL Engine?

Aug 28, 2008

How to know the version of PL/SQL Engine

View 1 Replies View Related

SQL & PL/SQL :: How To Know Uses Of Oracle 9i Version

May 31, 2010

How to know the uses to oracl9i version ?

View 2 Replies View Related

XE :: Download And Use Version For Mac Using OS X 10.4.11

Jun 14, 2012

Can I download & use a version for a Mac using OS X 10.4.11?

View 1 Replies View Related

ODP.NET :: Upgrading From Version 10 To 11

Jun 6, 2013

We have several applications hosted on a server using ODP.NET 10, but we are the first to decide to upgrade to ODP.NET 11 which means we need a method where only our application uses ODP.NET 11 without affecting any other existing applications.

I've read about the policy files which automatically redirects application to use latest version installed on the machine. Is there a method available which can avoid this situation as the owners of other application may not allow this to happen.

How can I ensure that my application is using ODP.NET 11 or ODP.NET 10 if both are installed? I created two sample app one with Oracle.DataAccess.dll 10.2.0.100 and other one with Oracle.DataAccess.dll 2.112.3.0. With below line of code, I found both applications are showing Oracle.DataAccess 2.112.3.0 at runtime.

System.Data.Common.DbProviderFactories.GetFactoryClasses();

Last thing, I may be wrong saying latest ODP.NET wouldn't work with NHibernate 1.0.3.0. please validate.

View 4 Replies View Related

Difference Between Oracle Version 10.2.0.3 And 10.2.03?

May 28, 2008

difference between oracle version 10.2.0.3 and 10.2.03.I searched a lots of sites to get the details about these versions but unable to collect.

Oracle released both version or 10.2.0.3 and 10.2.03 are same versions treated by oracle.

View 2 Replies View Related

Select Row With Highest Version

Aug 25, 2010

My table holds info on documents:

|doc_id|auth|version|date_created|

so what I'm trying to do is select the latest version of each document record.

so say I have there records:

doc_uid|doc_id|auth|version|date_created|
|1 | 100 |al |0.1 |11/4/08 |
|1 | 101 |al |0.2 |11/4/08 |
|2 | 102 |al |0.4 |11/4/08 |

So i want to select only one copy of every doc_uid(unique id) with the highest version number, which would make my output:

doc_uid|doc_id|auth|version|date_created|
|1 | 101 |al |0.2 |11/4/08 |
|2 | 102 |al |0.4 |11/4/08 |

doc_id 100 was excluded because it has a higher version which was shown instead.

So how would i express this is oracle sql.

edit: Just thought i should say that I have been tring to crack this for 2 days now :P I have been messing around with MAX() but I cant make it do what i want.

View 6 Replies View Related

Forms :: 10g Version Control

Mar 17, 2010

Oracle's Software Configuration Manager version 10.1.2.5 with forms version 10.1.2.3.0:

Is this what everybody is using to manage their forms development? If not, what are developers using for Forms 10g version control? I've installed this software. I'm using the Oracle XE database for this repository. At least for running through the tutorial to figure out how this is to work.

I have to say that I am frustrated that I cannot compare one version of a form to another version of the same fmb. I get a java null pointer exception. I have uninstalled the repository using RAU, then recreated it using the RAU. I'm using version control and defining a "large" repository type for more than 10 developers.

View 6 Replies View Related

RAC & Failsafe :: Software Version In RAC

Jul 14, 2013

I heard, in RAC environment both clusterware software and oracle software should have similar version.how to find the version of both softwares ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved