One data files to multiple data files.

Hello.
I have a database with single data file and i want to split that data across
multiple data files.
Coulf u pls help me how to achieve this
Thanks,
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1please see BOL for Files and Filegroups

One data files to multiple data files.

Hello.
I have a database with single data file and i want to split that data across
multiple data files.
Coulf u pls help me how to achieve this
Thanks,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1
please see BOL for Files and Filegroups
sql

One data files to multiple data files.

Hello.
I have a database with single data file and i want to split that data across
multiple data files.
Coulf u pls help me how to achieve this
Thanks,
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1please see BOL for Files and Filegroups

OMG: an Oracle Question :)

Hello...

I have a small Oracle question... *ducks*

In SQL-Server I can return more then one resultset in a single stored Procedure (Get Parents and all child Objects for that/those parent(s))... Is the same possible in Oracle? I think I remember that Oracle cant do that due to the different handling of Selects in SPs?

Thats it...

Also I want to know if there is a reverse Copy of the Book ""SQL Server 2000 for the Oracle DBA"

Oracle allows you to return one or more results via REF CURSOR parameters from functions/procedures. These are more powerful than just returning results. For example, you can pass REF CURSOR parameter from one procedure to another.