Answer Posted / 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 |
Post New Answer View All Answers
Can you redefine a table online?
What is fill factor? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
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?
What authentication modes does sql server support? : sql server DBA
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.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
what is the diffrence between core dba and apps dba?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
