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

Report message to a moderator

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: 68647
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

Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
You could also pre-create the objects in the tablespace you would like.

Report message to a moderator

Previous Topic: Import stalled with 'SQL*Net message from client' wait event
Next Topic: ASM AND RAID
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 14:41:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.