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

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1589


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1743


What is a system database and what is a user database? : sql server DBA

599


Why would you use sql agent? : sql server DBA

580


which background process invoke at the time of upgradation tell me???

2226






What is transparent data encryption? : sql server DBA

564


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1656


what is a user-defined lock?

587


what functionality does oracle provide to secure sensitive information?

554


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1901


What is fill factor? : sql server DBA

644


how can you implement fine-grained auditing?

606


How would you go about verifying the network name that the local_listener is currently using?

2757


What is dcl? : sql server DBA

646


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2059