oracle安装提示无sp,sp_dropdevice 不成功，为何？

1> use master

2> go

1> sp_dboption DB1, "single user",true

2> go

Database option 'single user' turned ON for database 'DB1'.

Running CHECKPOINT on database 'DB1' for option 'single user' to take effect.

(return status = 0)

1> use DB1

2> go

1> checkpoint

2> go

1>

2>

3> sp_dropsegment logsegment, 'DB1', 'log2'

4> go

DBCC execution completed. If DBCC printed error messages, contact a user with

System Administrator (SA) role.

DBCC execution completed. If DBCC printed error messages, contact a user with

System Administrator (SA) role.

The last-chance threshold for database DB1 is now 312 pages.

Segment reference to device dropped.

WARNING: There are no longer any segments referencing device 'log2'.  This

device will no longer be used for space allocation.

(return status = 0)

1> sp_dropdevice log2

2> go

Msg 17482, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropdevice', Line 78:

Device is being used by a database. You can't drop it.

database_name           device                size

----------------------- --------------------- ----------------------------

DB1                     log2                  2 MB

(1 row affected)

(return status = 1)

1> use master

2> go

1> sp_dboption DB1, "single user",true

2> go

Database option 'single user' turned ON for database 'DB1'.

Running CHECKPOINT on database 'DB1' for option 'single user' to take effect.

(return status = 0)

1> use DB1

2> go

1> checkpoint

2> go

1>

2> sp_dropsegment 'logsegment', 'DB1', 'log2'

3> go

Msg 17523, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropsegment', Line 290:

Segment 'logsegment' does not reference device 'log2'.

(return status = 1)

1> sp_dropsegment 'system', 'DB1', 'log2'

2> go

Msg 17523, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropsegment', Line 290:

Segment 'system' does not reference device 'log2'.

(return status = 1)

1> sp_dropsegment 'default', 'DB1', 'log2'

2> go

Msg 17523, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropsegment', Line 290:

Segment 'default' does not reference device 'log2'.

(return status = 1)

1> sp_dropdevice log2

2> go

Msg 17482, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropdevice', Line 78:

Device is being used by a database. You can't drop it.

database_name           device                size

----------------------- --------------------- ----------------------------

DB1                     log2                  2 MB

(1 row affected)

(return status = 1)

1> sp_dropsegment 'logsegment', 'DB1', 'log2'

2> go

Msg 17523, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropsegment', Line 290:

Segment 'logsegment' does not reference device 'log2'.

(return status = 1)

1> sp_dropsegment 'system', 'DB1', 'log2'

2> go

Msg 17523, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropsegment', Line 290:

Segment 'system' does not reference device 'log2'.

(return status = 1)

1> sp_dropsegment 'default', 'DB1', 'log2'

2> go

Msg 17523, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropsegment', Line 290:

Segment 'default' does not reference device 'log2'.

(return status = 1)

1>

2> dump tran DB1 with truncate_only

3> go

1> sp_dropdevice log2

2> go

Msg 17482, Level 16, State 1:

Server 'HP12770113212', Procedure 'sp_dropdevice', Line 78:

Device is being used by a database. You can't drop it.

database_name           device                size

----------------------- --------------------- ----------------------------

DB1                     log2                  2 MB

(1 row affected)

(return status = 1)

1>