Skip to main content

Create Table Space in Oracle DB

Following are the queries which can be used to create table space in Oracle DB.

 CREATE BIGFILE TABLESPACE "TABLESPACENAME" DATAFILE 'C:/oraclexe/app/oracle/oradata/TableSpaceName.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 alter TABLESPACE "TABLESPACENAME" AUTOEXTEND ON MAXSIZE unlimited;

 CREATE USER USERNAME IDENTIFIED BY PASSWORD DEFAULT TABLESPACE "TABLESPACENAME" TEMPORARY TABLESPACE temp;

 ALTER USER USERNAME QUOTA unlimited ON "TABLESPACENAME";

 grant all privileges to TABLESPACENAME;

 commit;

Comments

Post a Comment

Popular posts from this blog

How do I effectively explain my projects when asked in a technical Interview?

Like everything in an interview, think about this request from the interviewer’s perspective. What are they trying to learn? Why did they ask this? As an interviewer, I am looking for several things when I ask about a candidate’s project. Communication skills . Can they describe the project in 30 seconds? In five minutes? Can they effectively answer drill-down questions and convey a good answer about a technical detail? Role in project . Were they a leader, a follower, or a fixture to the side? Does their description and their knowledge align with what they say their role was? Technical savvy . Are they able to talk compellingly about the technology, its limits, its benefits? Can they support their technical choices or talk in a straightforward fashion about poor choices they made? Knowing what they know now, what would they do differently? Before you interview, read over your resume. Make sure you can give a 30-second elevator pitch about your projects, and a five-minute ...
Post a Comment
Read more
Dookudu (2011) FREE SONGS DOWNLOAD Cast : Mahesh Babu, Samantha Director : Srinu Vytla Producer : Achanta Ram, Achanta Gopinath & Anil Sunkara Music : Thaman S CLICK HERE
Post a Comment
Read more