This works for me .....
On the target DB ...
Create the schema owner and only give them quota on TBS2. Run your
import as the schema owner (may have to grant import full database role
temporarily) and your new schema will be in TBS2.
HTH, John
-----Original Message-----
From: kidambi
[mailto:oracledba-ezmlmshield-x98359643.[Email address protected]
Sent: 06 August 2007 06:49
To: LazyDBA Discussion
Subject: Importing data in an Oracle 9i Database
Hi all,
A case of importing data to a Oracle 9i database:
The source schema's default tablespace is TBS1 ( all the objects have
TBS1as their tablespace). I have specified the target schema's default
tablespace as TBS2 ( all the objects should have TBS2 as their
tablespace). In this scenario, I face 2 issues.
1) As TBS1 Tablesapace is available in target database also, all the
objects get imported into this tablespace eventhough I have specified
TBS2
as the target schema's default tablespace.
2) TBS1 Tablesapace is not available in target database. Receive an
error
mentioning that TBS1 tablespace does not exist eventhough I have
specified TBS2 as the target schema's default tablespace.
Please suggest a way by which I can overcome this issue and get the
source schema's objects imported into TBS2 tablespace in the target
side.
Thanks.
Kind regards,
Raj
"Save Paper - Do you really need to print this e-mail?"
This e-Mail may contain proprietary and confidential information and is
sent for the intended recipient(s) only. If by an addressing or
transmission error this mail has been misdirected to you, you are
requested to delete this mail immediately. You are also hereby notified
that any use, any form of reproduction, dissemination, copying,
disclosure, modification, distribution and/or publication of this e-mail
message, contents or its attachment other than by its intended
recipient/s is strictly prohibited.
Visit us at http://www.polaris.co.in
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
APAK Group Limited, Registered in England No. 01451033.
Registered office APAK House, Badminton Court, Station Road, Yate, Bristol, BS37 5HZ.
The information contained in this message or any of its attachments may
be privileged and confidential and intended for the exclusive use of the
addressee. The views expressed may not be APAK policy but the personal
views of the originator. If you have received this message in error, please
advise the sender immediately by reply e-mail and delete this message and
any attachments without retaining a copy. This footnote also confirms that
this email message has been swept for the presence of known computer
viruses before being sent.
**********************************************************************
Oracle LazyDBA home page