Re: Change default directory for the new extents

From: Reid Lai <reidlai_at_hk.super.net>
Date: Fri, 20 Nov 1998 00:17:57 +0800
Message-ID: <365444B4.5253195@hk.super.net>

Can the following statement help you to solve the problem:

ALTER TABLESPACE your_tablespace_name ALLOCATE EXTENT "your data file name" ;

I am sorry that I don't remember the exact syntax so please check against Oracle Server SQL manual.

Adam Rudzik wrote:

> Could someone tell me if there is a way to change
> the default directory for the physical files when
> new extents will be created. The disk where we
> keep Oracle data files is almost full and we would
> like to create data files on another (new) harddrive.
> We are running Oracle 7.3.3 on NT box.
> Thanks in advance.
>
> Adam

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Nov 19 1998 - 10:17:57 CST