Solved

Oracle 9i DB Import PBs

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Java / Linux and Regular Expressions 11 71
parse convert xml feed to text (python) 2 71
Linux hostname change 2 56
expectj telnet failing 5 26
Introduction We as admins face situation where we need to redirect websites to another. This may be required as a part of an upgrade keeping the old URL but website should be served from new URL. This document would brief you on different ways ca…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
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…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now