Answer / guest

alter databse datafile 'location of datafile' resize 2000M



Regards
Abhinav Phadnis

Answer / monal

in SQL Server 2005:

ALTER DATABASE <Database Name> MODIFY FILE
(NAME =<File Name>, MAXSIZE = <Size>)

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

How can you rebuild an index?

6 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

How do you resize a data file?

2 Answers  

---

Oracle 11g new features?

2 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

What is fill factor? : sql server DBA

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---