Home » RDBMS Server » Server Utilities » tablespace import (tablespace import)
tablespace import [message #542168] Sun, 05 February 2012 11:15 Go to next message
hemant_khandare
Messages: 72
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.


Re: tablespace import [message #542169 is a reply to message #542168] Sun, 05 February 2012 11:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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/
Re: tablespace import [message #542173 is a reply to message #542168] Sun, 05 February 2012 11:36 Go to previous messageGo to next message
John Watson
Messages: 8919
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".
Re: tablespace import [message #542174 is a reply to message #542168] Sun, 05 February 2012 11:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
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
Re: tablespace import [message #542176 is a reply to message #542174] Sun, 05 February 2012 11:45 Go to previous messageGo to next message
hemant_khandare
Messages: 72
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
Re: tablespace import [message #542177 is a reply to message #542176] Sun, 05 February 2012 11:53 Go to previous messageGo to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
dear sir, but still I am facing this issue.
Re: tablespace import [message #542178 is a reply to message #542177] Sun, 05 February 2012 11:59 Go to previous messageGo to next message
John Watson
Messages: 8919
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?
Re: tablespace import [message #542179 is a reply to message #542177] Sun, 05 February 2012 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
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
Re: tablespace import [message #542180 is a reply to message #542177] Sun, 05 February 2012 12:01 Go to previous messageGo to next message
John Watson
Messages: 8919
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.
Re: tablespace import [message #544022 is a reply to message #542180] Sun, 19 February 2012 07:11 Go to previous message
hemant_khandare
Messages: 72
Registered: November 2011
Member
thanks.
Previous Topic: exp and impdp
Next Topic: Netca and netmgr utilities
Goto Forum:
  


Current Time: Tue Mar 19 06:51:53 CDT 2024