Interested to Buy Any Domain ? << Click Here >> for more details...
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
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
who owns the operating system files created by the utl_file package?
What is the importance of a recovery model? : sql server DBA
what is logical system in sap basis
what is the use of ocr?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you create a user-defined lock?
how to restore files with rman?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is the role of dip user in our database?
What is the difference between clustered and non-clustered index? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
