Solved

Oracle 9i DB Import PBs

Posted on 2004-09-09
1
588 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Zimbra on Amazon Linux help 7 111
Syslog-ng works. Now what? How to filter and manage? 8 91
Redhat upgrade 1 48
Granting root permissions to a user (in Debian Jessie) 17 50
Network Interface Card (NIC) bonding, also known as link aggregation, NIC teaming and trunking, is an important concept to understand and implement in any environment where high availability is of concern. Using this feature, a server administrator …
How many times have you wanted to quickly do the same thing to a list but found yourself typing it again and again? I first figured out a small time saver with the up arrow to recall the last command but that can only get you so far if you have a bi…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

756 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