The error from the log file when I tried to drop:

Getting temporary tablespace from database...
[16-08-2007 11:14:19] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=sactd.ges.XXXX.com)(PORT=1545)))(CONNECT_DAT A=(SERVICE_NAME=SACTD))):

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach)


The listener for SACTD is running like this.

SACTD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sactd.ges.XXXX.com)(PORT = 1545))
)
)
)
~