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>)

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

. 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?

0 Answers  

---

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

0 Answers  

---

what are the differences of where and if in SAS?

0 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

How do you resize a data file?

2 Answers  

---