How do you add a data file to a tablespace?
Answers were Sorted based on User's Feedback
Answer / hemant shrimali (dba)
alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / vinoth kumar
alter tablespace <tablespacename> add datafile 'u01
\oradata\db\test01.dbf' size 10m autoextend on next 5m
maxsize 50m
in prodution database autoextend off is to be avoid.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Can we take incremental backups in datapump?
what is the use of recording information about current session?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
What is RAID and what are different types of RAID configurations?
Explain the difference between a data block, an extent and a segment.
Why does Oracle not permit the use of PCTUSED with indexes?
How to determine the service pack currently installed on SQL Server?
What are the operating modes in which database mirroring runs? : sql server DBA
Give the stages of instance startup to a usable state where normal users may access it.
What are the steps you will take, if you are tasked with securing an SQL Server?
You're getting high "busy buffer waits" - how can you find what's causing it?
What the different components in replication and what is their use? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)