As Oracle has evolved, the options for creating tablespaces have grown more complex, with more CREATE TABLESPACE options: You create tablespaces with the CREATE TABLESPACE command. Before you create the tablespace you should decide: 1. How big you wish the tablespace to be. 2. Where you want to put the datafile or datafiles that will be associated with that tablespace. 3. What you want to call the tablespace and the datafiles. We recommend that you include the following in the datafile name when you create the tablespace: 1. The name of the database 2. The name of the tablespace 3. A number that makes the datafile unique So, for a tablespace called USERS assigned to a database called BOOKTST we would have a datafile called booktst_users_01.dbf. Here is an example of creating such a tablespace using the create tablespace command: Note that we used 50m to indicate that we wanted to create the tablespace 50 Megabytes in size. You can also use the K symbol for Kilobytes, and the G symbol for Gigabytes. If you want to try to use the P symbol for a 50 Petabyte tablespace, we want to talk to you! There are several "create tablespace" options that determine how big the tablespace will be: Autoextend on: Creating a tablespace with autoextend on alleviates the potential problem of a database outage if the tablespace reaches maximum extents. You create a tablespace using autoextend with the autoextend on option. Using "create tablespace . . . autoextend on" will push the point of failure to the OS filesystem, which is good because you never want you database to hang because a tablespace cannot grow. With autoextend on, you only need to monitor the free space in the filesystem directory. Maxsize: This is the maximum size that the datafile can grow. We recommend creating a tablespace with maxsize unlimited to prevent a lock-up. Size: This is the size of the underlying data file for the tablespace. Blocksize: Specifying a larger blocksize will not result in a larger tablespace. See here on creating tablespaces with non-default blocksizes. Uniform size: This specifies the size that the data file will grow when it needs to extend. By default, an Oracle tablespace will not grow if it runs out of space. If you use up all your space, you are just out of luck unless you use the autoextend keyword to indicate that the tablespace may grow, on it?s own, dynamically. Here is an example of creating a tablespace that is set to autoextend:
Views: 5032 Mohammad Taseen
Much has been made of the 13-year gap between Shahid and Mira, who just graduated from Delhi's Lady Shri Ram college. They are believed to have met through the religious group Radha Soami Satsang, of which both families are members. Shahid's mother Neelima Azim described Mira as "sweet and extremely affectionate" in an interview to mid-day in May. The wedding venue: The wedding, with rituals in traditional Punjabi style, will be held at the Trident Hotel in Gurgaon, contrary to early reports that a destination wedding was planned in Greece. 50 rooms have been blocked, among them the grand Presidential Suite - a 5,300 sq ft space that has two bedrooms, dining room, study, pantry, its own gym and pool and reportedly costs Rs 6,00,000 per night. The hotel has been prepping for the nuptials some days and Shahid's family were spotted arriving at the Trident on Sunday. Those photographed included his father Pankaj Kapur, step-mother Supriya Pathak, and step-siblings Sanaah and Ruhaan. Shahid, meanwhile, has wrapped his shoot for reality show Jhalak Dikhhla Jaa and was spotted at Mumbai airport on Monday morning. Shahid Kapoor’s fans were under the impression that his wedding to Mira Rajput would take place in Greece in June. However, a source has told a Mumbai tabloid that the wedding will be in Delhi, in July. "Shahid is definitely getting married in July. We’ve all been asked to be free that time," the source said. Earlier, on March 26 actor Shahid Kapoor had confirmed that marriage, to Delhi-girl Mira, was "on the cards sometime towards the end of the year." "She is a normal girl and I am a normal guy, and we should treat it like something normal and regular. It’s my personal space and I won’t get into the details. I’m just happy to announce it," Shahid added. Mira is currently pursuing her graduation degree and has completed her schooling from Vasant Valley School. Apparently, Shahid met Mira through the religious group Radha Soami Satsang Beas. From Bali to Greece, rumours about the wedding destination were doing the rounds ever since the 34-year old actor confirmed the marriage, which is said to be an arranged one.
Views: 3105 Mohammad Taseen
how to fix putty network error connection refused problem SOLVED lets start to slove the error fallow these steps 1)go to linux 2)open terminal 3)type system-config-network 4)edit 5)set static ip address you can set any ip address here i m using 192.168.1.50 6)click ok 7)click on activate 8)service network restart ----------------------------------------------------------------------------------------------------------- command to change owner ship chown root:root /var/empty/sshd
Views: 217406 Mohammad Taseen
The Oracle DROP TABLESPACE command is used to remove a tablespace from the database. In the following example, we will drop the USELESS tablespace from our database using the Oracle DROP TABLESPACE command: Drop tablespace useless; The Oracle DROP TABLESPACE command Oracle will generate an error if objects reside in the tablespace. Do the following to remove all objects in the tablespace prior to using Oracle DROP TABLESPACE command: Drop tablespace useless including contents; Oracle does not clean up after itself wile using the Oracle DROP TABLESPACE command by default. An option exists to force Oracle to clean up after itself using the Oracle DROP TABLESPACE command. The following example illustrates the Oracle DROP TABLESPACE command used with the including contents and datafiles keywords: Drop tablespace useless including contents and datafiles;
Views: 146 Mohammad Taseen
How to buy shares in www.mytrafficvalue.com
Views: 430 Mohammad Taseen
Meanwhile, SRK, Aditya Chopra and director Maneesh Sharma have almost locked in on Bakri Eid for releasing Fan. The DNA report quotes a source, "The other holidays or festival release dates are already booked by other stars. None of the other holiday dates were free - be it Eid, Diwali, Gandhi Jayanti or Christmas. It was only Bakri Eid which gave Fan a window for a proper holiday release. Else, the team would have had to shift the film to 2016 - something SRK himself did not want." Bakri Eid falls on a Wednesday which implies that Fan is likely to gain from the long five-day opening weekend. If the film is not able to release that day, it might not release this year at all, adds the source. Holidays have long been synonymous with big banner Bollywood releases. 2015 will be no different. Among the big budget films set for release on festivals are Bajrangi Bhaijaan on Eid-ul-Fitr, Brothers on Independence Day, Singh is Bling and Rocky Handsome on Gandhi Jayanti, Prem Ratan Dhan Payo on Diwali and Bajirao Mastani on Christmas.
Views: 121 Mohammad Taseen