Q
Problem solve Get help with specific problems with your technologies, process and projects.

ORA-02248 error while trying to import

I want to migrate from Oracle 8.05 to Oracle 9i. I exported the database in 8.05 and then tried to import it in Oracle 9i. I am getting the following error: "ORA-02248." Plesae help me solve my problem.

I want to migrate from Oracle 8.05 to Oracle 9i. I exported the database in 8.05 and then tried to import it in Oracle 9i. I am getting the following error: "ORA-02248." Plesae help me solve my problem.
The ORA-2248 error is an "invalid option for ALTER SESSION" error. Make sure that your NLS_LANG and NLS_DATE_FORMAT environment variables are defined correctly. They are probably set to an incorrect setting for Oracle 9i. The import utility issues an ALTER SESSION command with these values in mind.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close