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


Please Help Members By Posting Answers For Below Questions

Why would you call update statistics? : sql server DBA

1039


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

1078


what are the differences of where and if in SAS?

2254


what is asm?

1116


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

1083


how can you create a user-defined lock?

1058


What is the difference between clustered and non-clustered index? : sql server DBA

1147


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2016


What is dbcc? : sql server DBA

1352


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

2494


How do you trace the traffic hitting a sql server? : sql server DBA

1634


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

1141


What are the different sql server versions you have worked on? : sql server DBA

1071


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

2614


What are the steps you will take to improve performance of a poor performing query?

2898