|
Free or affordable online
Oracle
- Tablespaces
courses, how-to articles, tutorials, tips, tools, books, degree
information and resources.
Bookmark
this site
Master
Course List
Tests & Exams
|
|
Online Oracle Course (Introduction)
In this six-week online course, you will
learn how to create an Oracle database, build various database
objects for the database, and write simple SQL statements that
access the data from the database. This course will teach you
how to write Data Definition Language statements to create,
update, and delete database objects. You will learn how to
execute Data Control Language statements to give or delete
access rights to database objects. You will write Data
Manipulation Language statements to insert, update, and delete
records from a database. Finally, you will learn how to query
the data and create finished reports.
Learn more or buy this course.
Also Available:
Online Oracle Course (Intermediate)
|
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
©
2010 Learning Link Finders, Inc. - All Rights Reserved - Modified
on 01/04/10
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.
|
