Oracle 9i DB Import PBs
Posted on 2004-09-09
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 18.104.22.168.0 - Production on Thu Sep 9 18:44:06 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Release 22.214.171.124.0 - Production
JServer Release 126.96.36.199.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;
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 ?