OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Full Import (Oracle 9.2, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Full Import [message #440224]

Thu, 21 January 2010 12:53

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"?

Report message to a moderator

Re: Full Import [message #440226 is a reply to message #440224]

Thu, 21 January 2010 13:01

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Full Import [message #440228 is a reply to message #440224]

Thu, 21 January 2010 13:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: Full Import [message #440229 is a reply to message #440228]

Thu, 21 January 2010 13:07

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.

Report message to a moderator

Re: Full Import [message #440230 is a reply to message #440229]

Thu, 21 January 2010 13:10

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Full Import [message #440231 is a reply to message #440229]

Thu, 21 January 2010 13:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Full Import [message #440234 is a reply to message #440226]

Thu, 21 January 2010 13:17

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 1191 times)

Report message to a moderator

Re: Full Import [message #440235 is a reply to message #440234]

Thu, 21 January 2010 13:20

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Full Import [message #440236 is a reply to message #440234]

Thu, 21 January 2010 13:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Full Import [message #440237 is a reply to message #440235]

Thu, 21 January 2010 13:29

muthu_dba
Messages: 17
Registered: December 2009
Location: Bangalore

Junior Member

The import log file is

Attachment: imp_full_log.LOG
(Size: 11.53KB, Downloaded 1224 times)

Report message to a moderator

Re: Full Import [message #440238 is a reply to message #440236]

Thu, 21 January 2010 13:30

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

Report message to a moderator

Re: Full Import [message #440239 is a reply to message #440238]

Thu, 21 January 2010 13:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Full Import [message #440240 is a reply to message #440239]

Thu, 21 January 2010 13:50

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.

Report message to a moderator

Re: Full Import [message #440241 is a reply to message #440240]

Thu, 21 January 2010 13:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 15 23:44:42 CDT 2024