USERSPACE1 By default 
Author Message
 USERSPACE1 By default

Is it possible to have another tablespace by default in the place of USERSPACE1
when we create a table without specifying the tablespace.
Thank you for your answers  

B.Marty

--
Ce message a ete poste via la plateforme Web club-Internet.fr
This message has been posted by the Web platform club-Internet.fr

http://www.***.com/



Mon, 09 Aug 2004 21:47:21 GMT
 USERSPACE1 By default

Hi,
create some user defined tablespaces and then create a table without
tablespace specification. I think the first user defined regular tablespace
is set to default.
With 7.2 you can restrict the use of tablespaces with the GRANT/REVOKE  USE
OF TABLESPACE statement.



Quote:

> Is it possible to have another tablespace by default in the place of
USERSPACE1
> when we create a table without specifying the tablespace.
> Thank you for your answers

> B.Marty

> --
> Ce message a ete poste via la plateforme Web club-Internet.fr
> This message has been posted by the Web platform club-Internet.fr

> http://forums.club-internet.fr/



Wed, 11 Aug 2004 11:17:54 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Default to tablespace other than userspace1?

2. user's default database defaults to MASTER, despite config otherwise

3. Non-default parameter not allowed after default parameter???

4. Default member - Using VBA for dynamic default member

5. DSN Default dB being overriden by Login's default dB

6. Stored Procedure Defaults (Can I use functions to get the default value)

7. SQl-default and default constraints

8. Access97: How to set form defaults based on SQL Server defaults

9. Non-default parameter not allowed after default parameter

10. Stored Procedure Defaults (Can I use functions to get the default value)

11. default datestamp of 12am of today's date for default value

12. default timestamp and default autoinc


 
Powered by phpBB® Forum Software