Home » RDBMS Server » Server Utilities » Full Import (Oracle 9.2, Windows XP)
Full Import [message #440224] Thu, 21 January 2010 12:53 Go to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
Hi,
First i Export a database using FULL parameter
exp system/manager log=full_log.log file=full_dump.dmp full=y compress=y;

The exported database has 1 user named "ram" with default tablespace "data". All the datas are exported successfully.

But when Imported using Full parameter
imp system/manager log=imp_newdb_log.log file=full_dump.dmp full=y

The username "karthi" was created. But the tables for karthi was not generated. Can anyone tell the procedure for "how to import using full parameter"?
Re: Full Import [message #440226 is a reply to message #440224] Thu, 21 January 2010 13:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

>>The exported database has 1 user named "ram" with default tablespace "data".
Sure? Prove it.
Post the export log.
Re: Full Import [message #440228 is a reply to message #440224] Thu, 21 January 2010 13:02 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>The username "karthi" was created.
CREATE USER KARTHI done by who/how/when?

>But the tables for karthi was not generated.
Of course not.
KARTHI does not have any objects in export file.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version


It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Full Import [message #440229 is a reply to message #440228] Thu, 21 January 2010 13:07 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
Sorry! one correction in my question. Actually the user RAM was created automatically during import operation. But the tables and datas for RAM was not imported.

Re: Full Import [message #440230 is a reply to message #440229] Thu, 21 January 2010 13:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what ever it is,
Import will not create users at it's will.
Those users must exist in source database. May without objects as BlackSwan stated.
Re: Full Import [message #440231 is a reply to message #440229] Thu, 21 January 2010 13:10 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
as previously posted


>>The exported database has 1 user named "ram" with default tablespace "data".
Sure? Prove it.
Post the export log.


please note

"ram" is different user than RAM
Re: Full Import [message #440234 is a reply to message #440226] Thu, 21 January 2010 13:17 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
I send the Export log for my export operation.
  • Attachment: full_log.log
    (Size: 23.76KB, Downloaded 139 times)
Re: Full Import [message #440235 is a reply to message #440234] Thu, 21 January 2010 13:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Most probably the datafile/tablespace does not exist in target or
import was unable to create one in same path as in dump file.
Subsequent table creation should have failed.
Your import log should give the error detail.
Re: Full Import [message #440236 is a reply to message #440234] Thu, 21 January 2010 13:21 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
now post contents of imp_newdb_log.log


Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
Re: Full Import [message #440237 is a reply to message #440235] Thu, 21 January 2010 13:29 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
The import log file is
Re: Full Import [message #440238 is a reply to message #440236] Thu, 21 January 2010 13:30 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Re: Full Import [message #440239 is a reply to message #440238] Thu, 21 January 2010 13:38 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>. importing CRMAN's objects into CRMAN

> "ALTER SESSION SET CURRENT_SCHEMA= "CRMAN""

>IMP-00003: ORACLE error 1435 encountered

>ORA-01435: user does not exist

>IMP-00000: Import terminated unsuccessfully

import aborted before even trying to import RAM user; which is why no tables
Re: Full Import [message #440240 is a reply to message #440239] Thu, 21 January 2010 13:50 Go to previous messageGo to next message
muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore
Junior Member
Can you tell the reason and solution for this problem?

Actually the user ram was created automatically. But the only the problem is that tables for that user was not imported.
Re: Full Import [message #440241 is a reply to message #440240] Thu, 21 January 2010 13:57 Go to previous message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
All answers are contained import log file

IMP-00017: following statement failed with ORACLE error 959:

"CREATE USER "CRMAN" IDENTIFIED BY VALUES '843C990B5487E526' DEFAULT TABLESP"

"ACE "CATLOG" TEMPORARY TABLESPACE "TEMP""

IMP-00003: ORACLE error 959 encountered

ORA-00959: tablespace 'CATLOG' does not exist


IMP-00017: following statement failed with ORACLE error 1119:

"CREATE TABLESPACE "CATLOG" BLOCKSIZE 8192 DATAFILE 'F:\ORACLE\ORADATA\NEWD"

"B\EX01.DVF' SIZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONL"

"INE PERMANENT SEGMENT SPACE MANAGEMENT AUTO"

IMP-00003: ORACLE error 1119 encountered

ORA-01119: error in creating database file 'F:\ORACLE\ORADATA\NEWDB\EX01.DVF'

ORA-27038: created file already exists

OSD-04010: <create> option specified, file already exists

I suspect that you tried to import more than once.

you might be able to work past error simply by adding

IGNORE=Y

on imp command line
Previous Topic: Getting Field in data file exceeds maximum length when using sqlldr
Next Topic: Extract the DDL SQL scripts of the objects in BULK
Goto Forum:
  


Current Time: Thu Sep 29 00:34:00 CDT 2016

Total time taken to generate the page: 0.10052 seconds