Home » RDBMS Server » Server Utilities » import utilities (Merged)
import utilities (Merged) [message #258724] Mon, 13 August 2007 08:17 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hi,

i have problem in import utilities...

i have create user and tablespace
but i m import the table then the system create default tablespace..

thanks and regards,
Anamika
Re: problem in import utilities [message #258737 is a reply to message #258724] Mon, 13 August 2007 08:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Grant quota to your user on tablespaces.

Regards
Michel
import utilities [message #259105 is a reply to message #258724] Tue, 14 August 2007 07:21 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
i have dmp file in c drive i want to import in e drive where my oracle is install how to do
Re: import utilities [message #259108 is a reply to message #259105] Tue, 14 August 2007 07:38 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Drive doesn't really matter. If directory DMP is in isn't your working directory, you'll have to include full path to it. Otherwise, simply
IMP username/password@database_alias FILE=filename.dmp LOG=imp_log.txt

This might have additional parameters; which ones, see by issuing
IMP HELP=Y
or, even better, visit ths Documentation page.

[Updated on: Tue, 14 August 2007 07:38]

Report message to a moderator

Re: import utilities [message #259112 is a reply to message #259105] Tue, 14 August 2007 07:42 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thanks

i want to create tablespace and that database go in the tablespace

and one more question

how to see the tablespace.the data is in the tablespace or not
Re: import utilities [message #259118 is a reply to message #259112] Tue, 14 August 2007 08:05 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
anamika_025 wrote on Tue, 14 August 2007 07:42
thanks

i want to create tablespace and that database go in the tablespace

and one more question

how to see the tablespace.the data is in the tablespace or not



HUH ??
Re: import utilities [message #259139 is a reply to message #259112] Tue, 14 August 2007 09:03 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Look at

DBA_TABLESPACES
DBA_OBJECTS

and then look at the data in those tables matching your tablespace.
Re: import utilities (Merged) [message #259276 is a reply to message #258724] Tue, 14 August 2007 22:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Look at dba_tables . In this you will see table name and corresponding tablespace_name.




Thanks.
Re: import utilities (Merged) [message #259580 is a reply to message #259276] Thu, 16 August 2007 00:45 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thanks a lot..
Re: import utilities (Merged) [message #259582 is a reply to message #258724] Thu, 16 August 2007 00:51 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Anamika


Nice name. I wish I would name my daughter to Anamika.
Re: import utilities (Merged) [message #259595 is a reply to message #259582] Thu, 16 August 2007 01:31 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thanks Arju,


i have one more question...

i have import a file and system not create any tablespace its mean the data gone that tablespace which i have created..

Re: import utilities (Merged) [message #259598 is a reply to message #258724] Thu, 16 August 2007 01:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

If the tablespace does not exist against the table then the data while importing it will go to default tablespace of the user by which you are importing data.
Re: import utilities (Merged) [message #259599 is a reply to message #259598] Thu, 16 August 2007 01:44 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
hey give me one example

and i m imported that i got a this line


"Import terminated successfully with warnings."

there is any problem or what.

Re: import utilities (Merged) [message #259602 is a reply to message #259599] Thu, 16 August 2007 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check what were the warnings, then you know if it a problem or not for you.

Regards
Michel
Re: import utilities (Merged) [message #259613 is a reply to message #258724] Thu, 16 August 2007 02:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Hope anamika you want this.
SQL> create tablespace test_anamika
  2  datafile '/oradata2/DataFile/test_anamika.dbf' size 10M;

Tablespace created.

SQL> create user anamika identified by anamika default tablespace test_anamika;

User created.

SQL> grant dba to anamika;

Grant succeeded.

SQL> connect anamika/anamika;
Connected.
SQL> create table test ( a number);

Table created.
SQL> select table_name from dba_tables where tablespace_name='TEST_ANAMIKA';

TABLE_NAME
------------------------------
TEST

SQL> host exp anamika/anamika file=/backup/arju1.dbf tables=test;

Export: Release 10.2.0.1.0 - Production on Thu Aug 16 13:02:46 2007

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           TEST          0 rows exported
Export terminated successfully without warnings.

SQL> desc test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  NUMBER

SQL> drop table test;

Table dropped.

SQL> connect / as sysdba
Connected.
SQL> drop user anamika cascade;

SQL> connect anamika/anamika
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> select user_name from dba_users;
SP2-0640: Not connected
SQL> connect / as sysdba
Connected.
SQL> drop tablespace test_anamika including contents and datafiles;

Tablespace dropped.

SQL> create tablespace arju
  2  datafile '/oradata2/DataFile/arju01.dbf' size 10M;

Tablespace created.

SQL> create user arju_test identified by arju default tablespace arju;

User created.

SQL> grant dba to arju_test;

Grant succeeded.

SQL> host imp arju_test/arju file='/backup/arju1.dbf' full=y

Import: Release 10.2.0.1.0 - Production on Thu Aug 16 13:09:45 2007

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

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

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

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing ANAMIKA's objects into ARJU_TEST
. importing ANAMIKA's objects into ARJU_TEST
. . importing table                         "TEST"          0 rows imported
Import terminated successfully without warnings.

SQL> connect arju_test/arju
Connected.
SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
TEST                           TABLE

SQL> desc test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  NUMBER

SQL> select table_name, tablespace_name from dba_tables where owner='ARJU_TEST';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEST                           ARJU
Re: import utilities (Merged) [message #259619 is a reply to message #259613] Thu, 16 August 2007 02:23 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thanks a lot Arju..

give some book reference..actually i do not have any related to DBA...


i understood ur example.

thanks again..
Re: import utilities (Merged) [message #259621 is a reply to message #258724] Thu, 16 August 2007 02:26 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

According to me I get much pleasure in oracle Documentation. So search
tahiti.oracle.com
and pick your version and then select documentation.
Re: import utilities (Merged) [message #259629 is a reply to message #259621] Thu, 16 August 2007 02:36 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thank you very much..
Re: import utilities (Merged) [message #259630 is a reply to message #258724] Thu, 16 August 2007 02:40 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

anamika_025 wrote on Mon, 13 August 2007 19:17
hi,

i have problem in import utilities...

i have create user and tablespace
but i m import the table then the system create default tablespace..

thanks and regards,
Anamika


About this don't invoke import operation by the user whose default tablespace is SYSTEM.I guess you invoke import operation by user SYS/SYSTEM.
Before invoke import see the default tablespace of the intended user.


Thanks you Anamika.
Previous Topic: hanged import
Next Topic: raw disks and file system
Goto Forum:
  


Current Time: Sat Dec 10 06:50:02 CST 2016

Total time taken to generate the page: 0.29708 seconds