on 04-21-2012 1:53 PM
Dear experts/Guru
Please let me know given below command use, how it works:
alter TABLESPACE <tbsp> ADD DATAFILE '<datafile>' size <nM> REUSE AUTOEXTEND ON NEXT <nM> MAXSIZE <nM>
It basically add a data file to a tablespace.
You will need to run this command as a user with DBA privileges.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sumit,
please check the oracle documentation: http://docs.oracle.com/cd/E11882_01/server.112/e26088/clauses004.htm#SQLRF01602
It is explained very well ...
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.