#1 Tablespace In Oracle (Hindi)

A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments. Once created, a tablespace can be referred to by name when creating database segments.
In this you'll learn to create new tablespace and managing quota on tablespace.
Email :- [e-mail]

[@MrAnurag619]

Excellent explanation

[@nitinmahajan8687]

Nice explanation sir ji.... Excellent and each statements are easily understand...🚩🚩 जय श्री राम.....🙏🙏🙏

[@BadaniSir]

JAI SHREE RAM :)

[@kasikosana3494]

@@BadaniSir jai sri ram

[@VikashKumar-bh5yh]

good explanation. keep coming with more oracle database lecture. thank you

[@sachinmaurya9107]

wow what a lecture sirr........keep it up made my day and cleared many concepts

[@kashish9285]

Excellent! :) This was extremely helpful in understanding the Tablespace Concept. Thank you sir! :)

[@BhavyaSinha-b6k]

You explained very nicely thnq so much

[@mohitmangal9361]

Sir , Do you have any training regarding Oracle PDB architecture on 19c in developer point of view. Also new features of 19c along with practical.

[@AnuragSingh-wx1oz]

Very nice.. keep doing

[@ThePahadiMumbaikar]

excellent work sir

[@trekwithchetaas]

Sir I have a doubt " fetch first 10 rows only " not working in oracle 11g

[@vijayrajjakhmola4615]

Very Nice and helping to clear understand. Thank you sir

[@JagdishVanail]

Good 1 sir

[@anandkanawade9895]

Very good video....please make a video of oracle architecture with parsing stages

[@BadaniSir]

yes anand , I'm working on the same.

[@ibrahimmuhammad9509]

Soft tooo your lectures

[@rupeshkudalkar2528]

Very nice explanation sir.

[@sujitpatil716]

Sir please make video on plsql which r very helpful to us

[@biswanathbiswas7977]

Give real world examples to make everyone understand easily.

[@vaibhavarudkar7872]

Sir ,Your Taking Oracle 19C training Course.

[@BadaniSir]

No vaibhav not now, will let you know I'll get some time from my schedule. For more I'm sorry

[@jagadeeshk3910]

Thank You Ji

[@tarunraj226]

Super sir

[@sanjayrohilla2093]

excellent sir

[@naveedshah1546]

Please tell me how to sqlplus open in notepad mode in case off query error for rectify??

[@afzalsami4215]

Really helpful...

[@vaibhavmoharkar2349]

Thank you sir.

[@SudhirKumar-qe3te]

Hello sir, Can I take personal training from you.

[@BadaniSir]

It really makes me happy that my contribution to the DBA community is helping people, but I'm really sorry sudhir I don't have time for that

[@varnikachoudhary1041]

Can sys user see the tables information while tablespace are on offline mode ?

[@mohammedajazquadri7869]

Good explanation

[@mokh4719]

Is this course for accidental dba?

[@akshaypatil3621]

Which application & version yu have used??

[@mohammedirfanshaikh9991]

Sir aapka lecture begin kahase hai Oracle DBA?

[@VikasKumar-pg5hq]

great sir

[@hammadalamsiddique3730]

sir is this playlist complete for oracle database administration job?

[@mohammedirfanshaikh9991]

Sir kya ye Oracle full course hai? Sir mujhe full Oracle DBA karna hai basic se

[@abdulmusawir1000]

Sir g where is your institute please inform me about your institute or place where u are teaching

[@naveedshah1546]

Sir please tell me how to open sqlplus in edit mode in notepad during query nest?

[@vaishalibhusari3393]

Nice explanation...can u please make video on rman backup

[@BadaniSir]

kzbin.info/www/bejne/nqvMlJmYgc6Yi5I

[@swagwalachintu4660]

sir last me apne read only ka btaya tha...agar hamen dobra write b karwana hy patients ke table me tw kon c commands use karyen gyen....matlb agr hmne kisi tablespace ko read only ko commond dedi tw dobara se write karwany ki commond kese dyen gyen

[@BadaniSir]

alter tablespace tablespace_name read write;

[@swagwalachintu4660]

@@BadaniSir thanks sir

[@anikbasak7641]

Sir, How to install Oracle dba?

[@tarunraj226]

Please make Full Oracle rac Videos

[@nareshtechnical3656]

Great Video...with nice explanation...just subscribed you 😊

[@BadaniSir]

Thanks for the sub!

[@amazingworldnk3493]

Oracle synonyms can you explain in hindi

[@justjyotshana3889]

Install kaise karna hai ye step bhi to btaiye

[@pomibhai5163]

sir can you give us ppt files of lectures ??

[@fayazmuhammad9737]

i like

[@BadaniSir]

[e-mail]

[@amanjaitly64]

Hello, I cant create a user - ORA-65096: invalid common user or role name. I am on 19c version. Can you please tell me where I am wrong.

[@BadaniSir]

Create user c##username identified by password;

[@BadaniSir]

Prefix c## before user name

[@amanjaitly64]

@@BadaniSir create user ellison identified by ellison default tablespace tbs01 quota 5m on tbs01; This worked too without prefix, I was on the cdb$root and it was showing that error. I switched to orclpdb thn I was able to create the user without prefix. Quick question(I am super new to dbarch) - We cant create user on cdb?(If not, thn why?) We can create user on pdbs only?

[@BadaniSir]

alter session to create common user

[@amanjaitly64]

@@BadaniSir yes i used alter session set container = orclpdb. I was able to create the user and give grant too. but now after the "select tablespace_name,username,max_bytes/1024/1024 as max_bytes from dba_ts_quotas where username='ELLISON';" command. I am not able to connect to ellison - SQL> conn ellison/ellison ERROR: ORA-01017: invalid username/password; logon denied

[@kushalnerani4376]

ORA-00959: tablespace 'WELCOM' does not exist how to solve it

[@BadaniSir]

Make sure your welcome tablespace is already exist to make it default for any user

[@kushalnerani4376]

@@BadaniSir it is already present SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS 2 FROM USER_TABLESPACES; TABLESPACE_NAME STATUS CONTENTS ------------------------------ --------- --------------------- SYSTEM ONLINE PERMANENT SYSAUX ONLINE PERMANENT UNDOTBS1 ONLINE UNDO TEMP ONLINE TEMPORARY USERS ONLINE PERMANENT WELCOME ONLINE PERMANENT DEMO ONLINE PERMANENT TBS_TEST ONLINE PERMANENT

[@kushalnerani4376]

plz sir help me..

[@kushalnerani4376]

ORA-65048: error encountered when processing the current DDL statement in pluggable database ORCLPDB ORA-00959: tablespace 'TBS_TEST' does not exist it happen same for tbs_test table space;

[@kushalnerani4376]

help me sir

[@fayazmuhammad9737]

sir can you give your email

[@BadaniSir]

[e-mail]

[@mohammedajazquadri7869]

good explanation