How do you add a data file to a tablespace?

Answer Posted / suman

alter database tablespace ts1 add datafile
'/u01/oradata/directory name/ts1.dbf' size 5m autoextend on;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what do you understand by fine-grained auditing?

828


what is ora 24313?what is the procedure to exclude that error?

2322


Explain about your sql server dba experience? : sql server DBA

767


How to start SQL Server in minimal configuration mode?

7315


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2249


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1742


what is logical system in sap basis

1356


What are the different types of upgrades that can be performed in sql server? : sql server DBA

896


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

1712


how can you get actual data change values from previous transactions in oracle?

810


what is grd?

838


what is the use of recording information about current session?

776


What is transparent data encryption? : sql server DBA

773


How would you extract DDL of a table without using a GUI tool?

2226


What are the different ways you can create databases in sql server? : sql server DBA

801