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

    Question

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

    a filegroup or ?..

    Is there any detail..


    Thanks

    Wednesday, November 21, 2012 12:17 PM

Answers

  • 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

    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:44 PM
    Wednesday, November 21, 2012 12:21 PM
  • 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

    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:43 PM
    Wednesday, November 21, 2012 12:22 PM
  • 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.


    • Edited by Rama Udaya Wednesday, November 21, 2012 12:39 PM
    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:43 PM
    Wednesday, November 21, 2012 12:24 PM
  • 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)

    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:43 PM
    Wednesday, November 21, 2012 12:30 PM

All replies

  • 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

    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:44 PM
    Wednesday, November 21, 2012 12:21 PM
  • 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

    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:43 PM
    Wednesday, November 21, 2012 12:22 PM
  • 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.


    • Edited by Rama Udaya Wednesday, November 21, 2012 12:39 PM
    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:43 PM
    Wednesday, November 21, 2012 12:24 PM
  • 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)

    • Marked as answer by Ajay.G Wednesday, November 21, 2012 12:43 PM
    Wednesday, November 21, 2012 12:30 PM
  • Is there any website from where I can map the things of sql server with oracle easily?

    Thanks

    Wednesday, November 21, 2012 12:44 PM