R – Oracle : Use two different versions of EXP on the same machine

dumpora-12705oracleoracle10g

i have a server (HP-UX) installed with Oracle 10g and several databases on it.

I've been asked to make dumps from these tables for a Oracle 8i database. In order to do this, i need to use the 8i version of the EXP (export) tool of Oracle.

It is still installed on my server but when i want to use it, i get the following error :

EXP-00056: ORACLE error 12705 encountered
ORA-12705: Cannot access NLS data files or invalid environment specified

I presume some files are missing or maybe one of the folder is not in the PATH but i can't find and i really don't want to break the 10g installation.

Someone knows how to do ?

Thanks

Best Answer

Install a 10G client on another system, without modifying the 8I database server, and connect from the client to the 8I database. Use the export utilities on the client to generate the export file.

Related Solutions

Sql – How to limit the number of rows returned by an Oracle query after ordering

You can use a subquery for this like

select *
from  
( select * 
  from emp 
  order by sal desc ) 
where ROWNUM <= 5;

Have also a look at the topic On ROWNUM and limiting results at Oracle/AskTom for more information.

Update: To limit the result with both lower and upper bounds things get a bit more bloated with

select * from 
( select a.*, ROWNUM rnum from 
  ( <your_query_goes_here, with order by> ) a 
  where ROWNUM <= :MAX_ROW_TO_FETCH )
where rnum  >= :MIN_ROW_TO_FETCH;

(Copied from specified AskTom-article)

Update 2: Starting with Oracle 12c (12.1) there is a syntax available to limit rows or start at offsets.

SELECT * 
FROM   sometable
ORDER BY name
OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;

See this answer for more examples. Thanks to Krumia for the hint.

Oracle – NLS_LANG setting for JDBC thin driver

For me the best response was by FoxyBOA to invoke java app with:

-Duser.country=en -Duser.language=en

Best Answer

Related Solutions

Sql – How to limit the number of rows returned by an Oracle query after ordering

Oracle – NLS_LANG setting for JDBC thin driver

Related Topic