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
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Query processing is slow(eg select query)how will u solve that
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the difference between clustered and non-clustered index? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
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
what functionality does oracle provide to secure sensitive information?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
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.
What are the operating modes in which database mirroring runs? : sql server DBA
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
Why would you use sql agent? : sql server DBA
what is logical system in sap basis
