In oracle there is a tablespace what it is equivalent to in sql server:
Question
Wednesday, November 21, 2012 12:17 PM
In oracle there is a tablespace what it is equivalent to in sql server:
a filegroup or ?..
Is there any detail..
Thanks
All replies (5)
Wednesday, November 21, 2012 12:21 PM ✅Answered | 1 vote
Yes, it's the filegroup to assign objects like tables, indexes, LOB to disk/file space as equivalent for tablespace in Oracle.
Olaf Helper
Wednesday, November 21, 2012 12:22 PM ✅Answered
Yes.. Please read the link
http://msdn.microsoft.com/en-us/library/ms152551.aspx
vt
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
Wednesday, November 21, 2012 12:24 PM ✅Answered
In SQL we dont have the tables space instead of we have file & file group,Table,page,extents...
But we do have the table , pages(data stores in the page) and extents(group of pages i,e 8 pages =1 Extent).
see
Physical Database Architecture
http://msdn.microsoft.com/en-us/library/ms179276%28v=sql.90%29.aspx
Files and Filegroups Architecture
http://msdn.microsoft.com/en-us/library/ms179316%28v=sql.105%29.aspx
Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.
Wednesday, November 21, 2012 12:30 PM ✅Answered
hallo ForSQLServer,
not a filegroup as itself but a combination of filegroup AND it's files.
e.g.
ALTER DATABASE Indexing ADD FILEGROUP MyCustomers;
ALTER DATABASE Indexing
ADD FILE
(
Name = 'Fle_For_MyCustomers',
FileName = 'D:\Program Files\Microsoft SQL Server\MSSQL11.DE_TST_T_01\MSSQL\DATA\My_Customers.ndf',
SIZE = 50MB,
MAXSIZE= 100MB,
FILEGROWTH = 10MB
) TO FILEGROUP [MyCustomers];
ALTER DATABASE Indexing
ADD FILE
(
Name = 'File_For_MyCustomers_2',
FileName = 'C:\Temp\My_Customers.ndf',
SIZE = 500MB,
MAXSIZE= 1000MB,
FILEGROWTH = 100MB
) TO FILEGROUP [MyCustomers];
So now you have a table space of 550 MB but max of 1100 MB. I have separated both files from each other by choosing different locations. That maybe an option for partitioned tables or partitioned view.
Uwe Ricken
MCITP Database Administrator 2005
MCITP Database Administrator 2008
MCITP Microsoft SQL Server 2008, Database Development
db Berater GmbH
http://www-db-berater.de
SQL Server Blog (german only)
Wednesday, November 21, 2012 12:44 PM
Is there any website from where I can map the things of sql server with oracle easily?
Thanks