Solved

Oracle 9i DB Import PBs

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Connect to CentOS (in a local VMWare VM) using Putty 7 224
The better OS Architecture 13 108
rsyslog raw message 4 60
RPM creation 6 49
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…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
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…
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…
Suggested Courses

739 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