Solved

Oracle 9i DB Import PBs

Posted on 2004-09-09
1
594 Views
Last Modified: 2008-02-01
Hello,

I am in the process of performing an import on an export file from Oracle 8i to Oracle 9i.
invoking the import utility, I get this:
-----
[oracle@Linux2005 OraHome]$ imp
 
Import: Release 9.2.0.4.0 - Production on Thu Sep 9 18:44:06 2004
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Username: system
Password:
 
Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
 
Import file: expdat.dmp > 080904.dmp
 
Enter insert buffer size (minimum is 8192) 30720> 9000
 
Export file created by EXPORT:V08.01.05 via conventional path
 
Warning: the objects were exported by ALCIE, not by you
 
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
List contents of import file only (yes/no): no >
-----
I answered yes to the next two questions.   and off things went ..
======
Finally.Import terminated succesfully without warnings..........
======
======
SQL> select tablespace_name from dba_tablespaces;
 
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
 
11 rows selected.
======
I get the feeling that no tablespaces are the contents where imported ??
 
I also tried the following:
[oracle@Linux2005 oracle]$ imp system/tiger FROMUSER=ALCIE FULL=Y 080904.dmp IGNORE=N
LRM-00105: '080904.dmp' is not a legal Boolean for 'full'
 
IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully
[======
imp system/tiger FROMUSER=ALCIE FULL=Y FILE=080904.dmp IGNORE=N

which also gave a bunch or errors....

Should I create a DB manually ?


PT

0
Comment
Question by:ptreves
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 20

Accepted Solution

by:
Gns earned 500 total points
ID: 12027108
> Should I create a DB manually ?
Yes, import/export will not create tablespaces ... How could it/they? You need adapt your 8i pfiles to 9i (mainly just try building a new db from them and tweaking the file(s) as needed... Been a while, but I don't remember there being loads of things to edit, just a few:-)... Oh and make sure your filesystem layout match (of course) and that you've got the space:-).
It also seems like you've not set all the necessary ORA* environment variables since it complains about that... Something like
ORA_NLS32=$ORACLE_HOME/ocommon/nls/admin/data
NLS_LANG=american_america.we8iso8859p1
export ORA_NLS32 NLS_LANG
might help with those errors.

As it is now, you'll have created the tables in the default tablespace... Don't remember if it's users or tools:-).

-- Glenn
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question