How do you add a data file to a tablespace?

Answer Posted / hemant shrimali (dba)

alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why would you call update statistics? : sql server DBA

573


how can you find out if a table can be redefined?

593


how can you initialize log miner?

573


who owns the operating system files created by the utl_file package?

560


What is a correlated sub-query? : sql server DBA

579






what are the performance views in an oracle rac environment?

555


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2967


How do you trace the traffic hitting a sql server? : sql server DBA

843


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1722


what is grd?

634


internal architecture

1754


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1511


What is replication? : sql server DBA

620


Query processing is slow(eg select query)how will u solve that

6502


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

553