Home » RDBMS Server » Server Utilities » problem to import table data
problem to import table data [message #560331] Thu, 12 July 2012 03:31 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,
i am trying to use exp/imp utility through cmd and exp/imp is done successfully as per message given at last. but data is not import in targeted user.

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Neetesh>exp

Export: Release 10.2.0.1.0 - Production on Thu Jul 12 14:18:04 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: scott/tiger@localdb

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP > d:/scott_data

(2)U(sers), or (3)T(ables): (2)U > t

Export table data (yes/no): yes > y

Compress extents (yes/no): yes > n

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

Export terminated successfully without warnings.

C:\Users\Neetesh>imp

Import: Release 10.2.0.1.0 - Production on Thu Jul 12 14:20:09 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username: localaepuser/flair22@localdb

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Import file: EXPDAT.DMP > d:/scott_data

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SCOTT, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > y

Import entire export file (yes/no): no > y

. importing SCOTT's objects into LOCALAEPUSER
Import terminated successfully without warnings.

C:\Users\Neetesh>

what is the problem here , please tell me.

thanx in advance....

[Updated on: Thu, 12 July 2012 03:56]

Report message to a moderator

Re: problem to import table data [message #560333 is a reply to message #560331] Thu, 12 July 2012 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic:

Michel Cadot wrote on Tue, 03 July 2012 12:41
As a reminder from your previous topic:

Michel Cadot wrote on Fri, 22 June 2012 17:46
I could help but as you don't feedback to those who help you, I think it is not worth to.

In addition, with any SQL question, Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel




Quote:
i am importing data fro scott but this trigger is on another user (localaepuser).
there is no relation of it to import,then why import can not be success.


The trigger is on ANY logon.

Regards
Michel

Re: problem to import table data [message #560334 is a reply to message #560333] Thu, 12 July 2012 04:27 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thank you very much sir for your guidance i will keep it in mind,
and exp/imp process is completed successfully as per message given by oracle. but data is not impoted in target user.

thanx agian...

[Updated on: Thu, 12 July 2012 04:28]

Report message to a moderator

Re: problem to import table data [message #560338 is a reply to message #560334] Thu, 12 July 2012 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You modify your question when I was posting, so now my answer seems completly insane mentioning a logon trigger and quoting something that both do not exist in your question.

Regards
Michel

[Updated on: Thu, 12 July 2012 04:40]

Report message to a moderator

Re: problem to import table data [message #560344 is a reply to message #560338] Thu, 12 July 2012 04:51 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
sorry for the inconvenience sir,
actully sir there was an error in my code , so i have to modify it but i started to modyfied it before your posting. sorry again.
Re: problem to import table data [message #560519 is a reply to message #560344] Fri, 13 July 2012 16:04 Go to previous messageGo to next message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
In the export at the following line:

"Table(T) or Partition(T:P) to be exported: (RETURN to quit) >"

You are supposed to enter the table name that you want to export but you did not, you hit enter, so the export did not export the table.
Re: problem to import table data [message #560639 is a reply to message #560519] Mon, 16 July 2012 03:06 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thank u very much for your kind reply.
Previous Topic: oracle table (2 Merged)
Next Topic: error in exp/imp in datapump utility
Goto Forum:
  


Current Time: Thu Sep 24 03:26:08 CDT 2020