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
What the different types of replication and why are they used? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Query processing is slow(eg select query)how will u solve that
what is the last version,the release date of that version and fix pack of ibm db2 udb?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
which background process invoke at the time of upgradation tell me???
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you schedule a job in database?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what do you understand by flashback feature of oracle?
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 view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different types of indexes available in sql server? : sql server DBA