Home » RDBMS Server » Server Utilities » Import Schema in different tablepaces (merged 3) (Oracle Database 10.2.0.1)
Import Schema in different tablepaces (merged 3) [message #427326] Thu, 22 October 2009 01:45 Go to next message
zeeshansheikh83@gmail.com
Messages: 3
Registered: October 2009
Location: Kuwait
Junior Member
Dear All,

I need help regarging small issue our developers have created some schemas in user and system tablespace and we are migrating to another server. I want to tranfer them in different tablespace non system tablespaces during migration.

I create schema in new database and assigned deafult tablespace to non system table space but still data was migrated in Users table space.

Please suggest how i can migrate data to a different table space.

Thanks
Re: Import Schema in different tablepaces (merged 3) [message #427332 is a reply to message #427326] Thu, 22 October 2009 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not give any quota nor grant resource role or unlimitd tablespace to your user.

Regards
Michel
Re: Import Schema in different tablepaces (merged 3) [message #427412 is a reply to message #427326] Thu, 22 October 2009 08:30 Go to previous message
joy_division
Messages: 4616
Registered: February 2005
Location: East Coast USA
Senior Member
You could also pre-create the objects in the tablespace you would like.
Previous Topic: Import stalled with 'SQL*Net message from client' wait event
Next Topic: ASM AND RAID
Goto Forum:
  


Current Time: Mon Sep 26 17:54:47 CDT 2016

Total time taken to generate the page: 0.27217 seconds