| Alter Tablespace [message #63555] |
Fri, 15 October 2004 05:26  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
ALTER TABLESPACE users
ADD DATAFILE '/u02/oracle/rbdb1/users03.dbf' SIZE 10M
AUTOEXTEND ON
NEXT 512K
MAXSIZE 250M;
In the above Alter Tablespace command,
do I need to create DIRs orace/rbdb1 under /u02, before i the command?
do i need to create file users03.dbf also before i the command?
if yes, then who should i log-in as, oracle?
|
|
|
|
| Re: Alter Tablespace [message #63556 is a reply to message #63555] |
Fri, 15 October 2004 06:01  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
Hi,
it seems your database is already existing if that is the case it will have the location existing on your system no need to create location.
just type select name from v$datafile it will display existing file and locations
the command itself will create a datafile and added to the tablespace called users
you need to log on as sys user to make this operation
Regards
Dilip
|
|
|
|
| Re: Alter Tablespace [message #63557 is a reply to message #63556] |
Fri, 15 October 2004 06:14 |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
|
Well, the exisiting ones are not on /u02/ the existing ones are on /u09/ and now i am trying to add a datafile to users tablespace. /u02/ one is fresh one, i dont see any DIRs on /u02/, so do i need to create the DIRs oracle/rbdb1 on /u02/ if not existing? and who should i log-in as to create DIRs on UNIX? is it oracle?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
