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 add a data file to a tablespace?

Answer Posted / hemant shrimali (dba)

alter tablespace T1
add datafile 'c:\xx\T1.dbf' size 4M autoextend off;

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the differences of where and if in SAS?

2128


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1041


what are the performance views in an oracle rac environment?

998


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

2223


what is grd?

1045


how can you connect from 10g user to 11g user??

2059


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1919


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2274


what is the role of dip user in our database?

2362


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

2640


What are the different types of upgrades that can be performed in sql server? : sql server DBA

1149


how can you process messages in order asynchronously?

928


What the different topologies in which replication can be configured? : sql server DBA

1174


what is ora 24313?what is the procedure to exclude that error?

2518


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2043