Free and Affordable Online and Distance Education Courses

Free and affordable Oracle®: Tablespace courses, tutorials, tips, how-to articles, tools, books, degree information and resources.

Bookmark this site

Master Course List

Tests & Exams

Distance Learning Help

More Free Stuff

Computer Courses

Oracle Course Topics:

Backup / Recovery
Database
Getting Started
Security
Stored Procedures
Tablespace / Table / Index
Tuning & Performance
Users / Privileges
Utilities

 

 

 

 

NFL PhotoStamps - Click Here.

ECPI College of Technology - Promote Yourself Quickly With ECPI's Online Degree!

Test Your Knowledge
Free Tests & Exams

Free Oracle Tests

 

Kaplan - Earn Your IT Degree Online
If you are interested in advancing your IT career in programming, web development, database management, or networking, Kaplan University will give you the knowledge and skills you need.

 

Oracle Magazine - Free Subscription
Oracle Magazine contains technology-strategy articles, sample code, tips, Oracle and partner news, an all-new Oracle Developer section for Java developers, and more. No hidden or trial offers. Publication is absolutely free to those who qualify.

 

Affordable Training & Certifications

Oracle 10g Tutorials
In this VTC tutorial you will install and configure an Oracle 10g database, as well as review several programming choices to work with your database. First 3 lessons are free.

Oracle: Introduction to Oracle SQL and PL/SQL Tutorials
Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. First 3 lessons are free.

Oracle: Performance Tuning (1Z0-033) Tutorials
This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. First 3 lessons are free.

Oracle Database Administration Fundamentals
This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. First 3 lessons are free.

Exams: Oracle PL SQL - Oracle DBA - Oracle Suite

Prove your knowledge & skills. ExpertRating offers online Oracle tests which can be taken from any computer with an Internet connection. Candidates who pass the test receive a hard copy certificate of accomplishment. Each test is $24.95

 

Rollback Segments
Rollback segments are areas in your database which are used to temporarily save the previous values when some updates are going on.

 

Moving, Rebuilding and or Resizing Indexes
As this procedure deals only with indexes, I consider it a very low risk process. The main source of risk if any is if your target tablespace for the index is either low on available space or is very fragmented. Just because the index was removed from a tablespace does not mean it can be recreated in the same tablespace. Unless there is sufficient free space and or contiguous extents in the target tablespace the index may not recreate.

 

 

Tablespaces

When you create an Oracle database, you assign to it a number of files, which can be seen as a pool of free space made available to the database. Files are organized in tablespaces (a file belongs to a single tablespace). Except in a handful of statements, only tablespaces, not files, are referenced in SQL commands.

 

Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates.

 

Site Map  •  FAQs  •  Link to Us  •  Educational Gift Ideas  •  Add a Course  •  Contact Us

© 2008 Learning Link Finders, Inc. - All Rights Reserved - Modified on 01/01/08

All trademarks and registered trademarks appearing on the Docnmail.com website are the property of their respective owners.
By providing links to other sites, Learning Link Finders, Inc. does not guarantee, approve or endorse the information or products available
at these sites, nor does a link indicate any association with or endorsement by the linked site to Docnmail.com.