tablespace copy and rename

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

Klaus Baumgart wrote:

Klaus Baumgart · *nix forums beginner Joined: 09 Feb 2005 Posts: 3

How can I rename a tablespace without copying the database.
Also I have to change the Database User and Schemaname

I would like to do this simelar to the SQL-Server features.

copy Files
cp ALT_NAME NEW_NAME

EXEC sp_attach_db @dbname=N'NEW_NAME',
@filename1= N'E:\db\NEW_NAME.mdf',
@filename2= N'E:\db\NEW_NAME.ldf'

EXEC sp_addlogin 'NEW_NAME', 'NEW_NAME', 'NEW_NAME'
GO
USE NEW_NAME
GO
EXEC sp_grantdbaccess 'NEW_NAME', 'NEW_NAME'
GO
EXEC sp_addrolemember 'db_owner', 'NEW_NAME'
GO
USE NEW_NAME
GO
EXEC sp_revokedbaccess 'NEW_NAME'
GO
EXEC sp_changedbowner 'NEW_NAME'
GO

Google