Home » SQL & PL/SQL » SQL & PL/SQL » How to increase quota size for table space ?
How to increase quota size for table space ? [message #23522] Sat, 14 December 2002 21:25 Go to next message
Dhiren Patel
Messages: 16
Registered: December 2002
Junior Member
How to increase quota size for table space ?

Report message to a moderator

Re: How to increase quota size for table space ? [message #23525 is a reply to message #23522] Sun, 15 December 2002 04:27 Go to previous message
Mark
Messages: 284
Registered: July 1998
Senior Member
two ways: Manually,
ALTER DATABASE
DATAFILE ‘/DISK5/app_data_01.dbf’
RESIZE 200M;

or
Add another file to the tablespace:

ALTER TABLESPACE app_data
ADD DATAFILE ‘ /DISK5/app_data_01.dbf ’
SIZE 200M;

Report message to a moderator

Previous Topic: cursor in condition rule(if..elsif...end if;)
Next Topic: utl_smtp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 03:22:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.