Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do you resize a data file?

Answer Posted / guest

alter databse datafile 'location of datafile' resize 2000M



Regards
Abhinav Phadnis

Is This Answer Correct ?    13 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2249


how can you get actual data change values from previous transactions in oracle?

1056


how can you generate profile of pl/sql applications to identify performance bottlenecks?

1041


how can you communicate with operating system files from oracle?

1008


What is fill factor? : sql server DBA

1197


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2111


Why would you call update statistics? : sql server DBA

961


what is grd?

1061


What is the importance of a recovery model? : sql server DBA

982


how can you create a user-defined lock?

979


What is a system database and what is a user database? : sql server DBA

1140


what are the differences of where and if in SAS?

2150


what are the types of connection load-balancing?

955


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

2506


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2671