OraFAQ Forum: Server Administration » Transportable tablespace

Home » RDBMS Server » Server Administration » Transportable tablespace (AIX 6.1 - Oracle 11.2.0.3)

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

Transportable tablespace [message #618088]

Mon, 07 July 2014 11:33

s.m.ramachandran
Messages: 20
Registered: September 2012

Junior Member

Hi,

I am using Transportable Tablespace for my database movement, where i have 5000+ datafiles. I tried to move the tablespace in single export and import, but i got maximum number of DB_FILES exceeded. And i tried with 300 data file, it's success.

Kindly let me know the number of datafiles, that allowed for movement using transport tablespace.

Thanks & Regards
Ramachandran

Report message to a moderator

Re: Transportable tablespace [message #618094 is a reply to message #618088]

Mon, 07 July 2014 12:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

http://docs.oracle.com/cd/E16655_01/server.121/e17615/refrn10039.htm#REFRN10039

[Updated on: Mon, 07 July 2014 12:21]

Report message to a moderator

Re: Transportable tablespace [message #618099 is a reply to message #618088]

Mon, 07 July 2014 13:41

s.m.ramachandran
Messages: 20
Registered: September 2012

Junior Member

Hi Swan,

Thanks. After Changing the parameter issue resolved.

Thanks & Regards
Ramachandran

Report message to a moderator

Previous Topic:	View to check user connections
Next Topic:	Connection between application and database server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 03:00:13 CDT 2023