IMPORT problem [message #536285] |
Tue, 20 December 2011 03:03 |
|
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 #536299 is a reply to message #536291] |
Tue, 20 December 2011 03:26 |
John Watson
Messages: 8962 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
hemant_khandare wrote on Tue, 20 December 2011 09:20import 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 #536373 is a reply to message #536369] |
Tue, 20 December 2011 08:17 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
You seem to have not understood them as I didn't see any feedback on your previous topics.
Regards
Michel
|
|
|