?
Solved

Oracle 9i DB Import PBs

Posted on 2004-09-09
1
Medium Priority
?
601 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 1500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
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.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

718 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