Share via

In oracle there is a tablespace what it is equivalent to in sql server:

  • Article

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

Blog Xing

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