Home » SQL & PL/SQL » SQL & PL/SQL » Constraint tablespace
Constraint tablespace [message #1925] Tue, 11 June 2002 10:49 Go to next message
Jon
Messages: 483
Registered: May 2001
Senior Member
Is there a way to define a tablespace for a constraint?

Report message to a moderator

Re: Constraint tablespace [message #1927 is a reply to message #1925] Tue, 11 June 2002 11:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Its not clear what you are actually looking into.
Constraint like primary key constraint, creates its own indexes. Only then, u may need to have the index in a seperate tablespace, because these indexes may affect the performance, if they are also placed in the same tablespace.

Report message to a moderator

Re: Constraint tablespace [message #1929 is a reply to message #1925] Tue, 11 June 2002 11:28 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
Mahesh et al,

What I would like to do is use the alter table command to add a constraint and store that constraint in a specific tablespace but cannot get the syntax to work, any ideas.

Report message to a moderator

Previous Topic: LONG datatype Oracle8.0.5
Next Topic: Name Matching Algorithim
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:04:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.