import utilities (Merged) [message #258724] |
Mon, 13 August 2007 08:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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: import utilities [message #259108 is a reply to message #259105] |
Tue, 14 August 2007 07:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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, simplyIMP username/password@database_alias FILE=filename.dmp LOG=imp_log.txt
This might have additional parameters; which ones, see by issuingor, 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 (Merged) [message #259613 is a reply to message #258724] |
Thu, 16 August 2007 02:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Arju
Messages: 1554 Registered: June 2007 Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
![a_arju](/forum/theme/orafaq/images/yahoo.png) ![arjuiut](/forum/theme/orafaq/images/google.png)
|
|
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
|
|
|
|
|
|
|