OraFAQ Forum: Server Utilities » tablespace import

Home » RDBMS Server » Server Utilities » tablespace import (tablespace import)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

tablespace import [message #542168]

Sun, 05 February 2012 11:15

hemant_khandare
Messages: 65
Registered: November 2011

Member

Hi sir ,

I have schema dump file of user hemant and its default tablespace
was users ,now I have created new user called amol and also created new tablespace with name amol and I sets user amol default tablespace to newly created tablespace amol and after that I executed my import script but after that when I am checking this tables in dba_tablespace view it is showing tablespace users but I want to import it in new tablespace.

I could not understand what happen ,Please guide me .
script is as below:

=============

create user amol identified by amol;--create user

grant dba to amol;---grant rights

revoke unlimited tablespace from amol;

create tablespace amol
datafile 'C:\app\Amol\oradata\orcl\amol.dbf' size 500m autoextend on;--create tablespace

ALTER USER amol
DEFAULT TABLESPACE amol ;

ALTER USER amol QUOTA unlimited ON amol
QUOTA 0 ON users ;

=====================

then I executed import script as below
impdp 'sys/sysdba@orcl as sysdba' schemas=hemant remap_schema=hemant:amol directory=TEST_DIR dumpfile=hemantfull.dmp
=======================
select *
from dba_tables a
where a.OWNER='AMOL'
===========
OWNER TABLE_NAME TABLESPACE_NAME
1 AMOL ABM_CV_FLOOR_FACTOR_NEW USERS
2 AMOL ABM_CV_FLOOR_MASTER USERS
3 AMOL ABM_CV_SDRR_NEW USERS
4 AMOL ABM_FLAT USERS
5 AMOL ABM_PROPERTY1 USERS
6 AMOL ABM_PROPERTY_TYPE USERS
7 AMOL ABM_STREET USERS
8 AMOL ABM_SYSTEM_LOOKUP USERS
9 AMOL ABM_SYSTEM_LOOKUP_VALUE USERS
10 AMOL ABM_TAXCODE_DETAILS USERS
11 AMOL ABM_TAXCODE_MASTER USERS
12 AMOL ABM_USER USERS
13 AMOL BONUS USERS
14 AMOL DUMMY USERS
15 AMOL HH USERS
16 AMOL NM USERS
17 AMOL SALGRADE USERS
18 AMOL DEPT USERS
19 AMOL EMP USERS
20 AMOL CV_PROPERTY_MASTER USERS
21 AMOL CV_ASSESSMENT USERS
22 AMOL CV_FLAT_MASTER USERS
23 AMOL GRAPHICS_TABLE USERS
======================================

but i want to import it in amol tablespace.

Report message to a moderator

Re: tablespace import [message #542169 is a reply to message #542168]

Sun, 05 February 2012 11:24

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

the tables need to be pre-created in the desired tablespace prior to the import

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: tablespace import [message #542173 is a reply to message #542168]

Sun, 05 February 2012 11:36

John Watson
Messages: 3101
Registered: January 2010
Location: Global Village

Senior Member

Hello, Hemant. I think this is the fourth topic you have opened on this subject? But you still refuse to use the [code] tags, so your posts are unpleasant to read. I think you have already been given the answer to this question, but I don't think your ever said "thank you".

Report message to a moderator

Re: tablespace import [message #542174 is a reply to message #542168]

Sun, 05 February 2012 11:36

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

grant dba to amol;---grant rights

The error is there.
Do NOT grant DBA to a user that do not need it (and in general do NOT grant DBA create your own dba roles).

Regards
Michel

Report message to a moderator

Re: tablespace import [message #542176 is a reply to message #542174]

Sun, 05 February 2012 11:45

hemant_khandare
Messages: 65
Registered: November 2011

Member

dear John sir pls refer and see my thanks note
http://www.orafaq.com/forum/mv/msg/177886/538514/0/#msg_538514

Report message to a moderator

Re: tablespace import [message #542177 is a reply to message #542176]

Sun, 05 February 2012 11:53

hemant_khandare
Messages: 65
Registered: November 2011

Member

dear sir, but still I am facing this issue.

Report message to a moderator

Re: tablespace import [message #542178 is a reply to message #542177]

Sun, 05 February 2012 11:59

John Watson
Messages: 3101
Registered: January 2010
Location: Global Village

Senior Member

So can you use [code] tags yet? And say "thank you" at the end of all your topics?

Report message to a moderator

Re: tablespace import [message #542179 is a reply to message #542177]

Sun, 05 February 2012 12:00

Michel Cadot
Messages: 54124
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

After what?
You reply to your post, how could we know to whom you actually reply?

Regards
Michel

Report message to a moderator

Re: tablespace import [message #542180 is a reply to message #542177]

Sun, 05 February 2012 12:01

John Watson
Messages: 3101
Registered: January 2010
Location: Global Village

Senior Member

And in the meantime, you might want either to read BlackSwan's answer, or to investigate the remap_tablespace option.

Report message to a moderator

Re: tablespace import [message #544022 is a reply to message #542180]

Sun, 19 February 2012 07:11

hemant_khandare
Messages: 65
Registered: November 2011

Member

thanks.

Report message to a moderator

Previous Topic:	exp and impdp
Next Topic:	Netca and netmgr utilities

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 04:19:55 CDT 2013

Total time taken to generate the page: 0.10514 seconds