Home » RDBMS Server » Server Utilities » IMPORT problem (IMPORT problem)
IMPORT problem [message #536285] Tue, 20 December 2011 03:03 Go to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
I have dump file of 17 GB,which i want to import in my database db1
in user amol ;so i created new user under db1 as below ,before this i have created tablespace so that i can import my data only to that tablespace only. My steps are as below.



CREATE TABLESPACE ptaxold1 DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/cvsdbm/ptaxold1.dbf' SIZE 6024M AUTOEXTEND ON;


create user amol identified by amol default tablespace ptaxold1 temporary tablespace tem;

imp amol/amol

then i mentioned my dump file but after importing it does not show any table under user amol.

Kindly suggest.


Re: IMPORT problem [message #536286 is a reply to message #536285] Tue, 20 December 2011 03:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does the log file say?
Re: IMPORT problem [message #536290 is a reply to message #536285] Tue, 20 December 2011 03:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Do not (try to) explain what you did, SHOW us: copy and paste your session.

2/ Feedback to those that answered and helped you: review your previous topics and post accordingly.

Regards
Michel
Re: IMPORT problem [message #536291 is a reply to message #536286] Tue, 20 December 2011 03:20 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
import successfully
Re: IMPORT problem [message #536292 is a reply to message #536291] Tue, 20 December 2011 03:20 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
or tell me steps to import with example
Re: IMPORT problem [message #536293 is a reply to message #536292] Tue, 20 December 2011 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Waiting for your feedback in your previous topics.............

Regards
Michel
Re: IMPORT problem [message #536298 is a reply to message #536293] Tue, 20 December 2011 03:26 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
help me
Re: IMPORT problem [message #536299 is a reply to message #536291] Tue, 20 December 2011 03:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
hemant_khandare wrote on Tue, 20 December 2011 09:20
import successfully
Yes, but what else does the log say? For example:
c:\users\john\home>imp scott/tiger

Import: Release 11.2.0.3.0 - Production on Tue Dec 20 09:23:12 2011

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

Import data only (yes/no): no >

Import file: EXPDAT.DMP > emp.dmp

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V11.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no >

Import grants (yes/no): yes >

Import table data (yes/no): yes >

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

. importing SCOTT's objects into SCOTT
. importing SCOTT's objects into SCOTT
. . importing table                          "EMP"         14 rows imported
Import terminated successfully without warnings.

c:\users\john\home>
Come on! You can do it!! With [code] tags!!! (You can even feedback on your other topics if you really try!!!!)
Re: IMPORT problem [message #536303 is a reply to message #536298] Tue, 20 December 2011 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
hemant_khandare wrote on Tue, 20 December 2011 10:26
help me


Just make the little effort and show the least respect to those that help you by giving a feedback.

Regards
Michel

Re: IMPORT problem [message #536365 is a reply to message #536291] Tue, 20 December 2011 08:00 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
hemant_khandare wrote on Tue, 20 December 2011 04:20
import successfully


That is not a valid Oracle message.
Re: IMPORT problem [message #536369 is a reply to message #536365] Tue, 20 December 2011 08:11 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
thanks to all for better guidance....
Re: IMPORT problem [message #536371 is a reply to message #536369] Tue, 20 December 2011 08:15 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
I solved my problem....thanks a lot .....
Re: IMPORT problem [message #536373 is a reply to message #536369] Tue, 20 December 2011 08:17 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You seem to have not understood them as I didn't see any feedback on your previous topics.

Regards
Michel
Previous Topic: Data Pump error
Next Topic: Datapump with DMP file, no other info
Goto Forum:
  


Current Time: Thu Mar 28 11:31:37 CDT 2024