Welcome! This is a website that everyone can build together. It's easy!

The Official Oracle WikiThis is a featured page

Welcome to the official public Oracle Wiki, where members of the Oracle community (employees and non-employees) collaboratively create and share content about Oracle-related subjects they're passionate about. Oracle employees, this is not an internal site!

Read the FAQ.
Read the Rules of Conduct.

If you have specific questions about Oracle products/associated technology, however, forums.oracle.com is still your best resource. The forums functionality you see here is intended to support Q&A about wiki content only.

Opinions expressed by wiki authors or commentators are entirely their own and do not reflect the position of Oracle. Any advice or recommendations discussed on this wiki (or sites it links to) are not validated by Oracle.

Oracle Wiki - What's New:






Wild-Kat
Wild-Kat
Latest page update: made by Wild-Kat , Aug 17 2010, 11:17 AM EDT (about this update About This Update Wild-Kat Edited by Wild-Kat


view changes

- complete history)
More Info: links to this page
Started By Thread Subject Replies Last Post
International_DBA Como se puede cambiar el nombre de un tablespace en Oracle 10 0 Friday, 2:59 PM EST by International_DBA
Thread started: Friday, 2:59 PM EST  Watch
En Oracle 10 se puede cambiar los nombres de los tablespaces.
Aquí hay un tablespace que se llama USERS:

SQL> select tablespace_name from dba_tablespaces
2 where tablespace_name in ('ANDREW', 'USERS')
3 /

TABLESPACE_NAME
------------------------------
USERS

Y una tabla que se llama ANDREWS_TABLE está en este tablespace:

SQL> select tablespace_name from dba_tables
2 where table_name = 'ANDREWS_TABLE'
3 /

TABLESPACE_NAME
------------------------------
USERS

Se puede cambiar el nombre del tablespace de la manera siguiente:

SQL> alter tablespace users rename to andrew
2 /

Tablespace altered.

SQL> select tablespace_name from dba_tablespaces
2 where tablespace_name in ('ANDREW', 'USERS')
3 /

TABLESPACE_NAME
------------------------------
ANDREW

Ahora las tablas que estaban en el tablespace USERS están en el tablespace ANDREW:

SQL> select tablespace_name from dba_tables
2 where table_name = 'ANDREWS_TABLE'
3 /

TABLESPACE_NAME
------------------------------
ANDREW
Do you find this valuable?    
Keyword tags: DBA Certitification
santo124 Oracle Enterprise Linux (page: 1 2) 29 Thursday, 6:45 AM EST by edwardgl
Thread started: Dec 12 2007, 2:36 AM EST  Watch
Is there anybody using Oracle Linux ? Please share experiences .
20  out of 65 found this valuable. Do you?    
Show Last Reply
brainsurface Join the Social Networking & IT Collaboration Gold Rush @ BrainSurface 1 Nov 17 2010, 8:45 PM EST by aobama52
Thread started: Nov 12 2010, 3:48 PM EST  Watch
BrainSurface | The After-Oracle ConnectSpace is the most Powerful, Advanced & Extensible Social Network & Collabaration platform for the Oracle & Java community!

BrainSurface is 100% integrated with Facebook & Twitter: Tweet and Share on Facebook with a few clicks: Right from BrainSurface! Don't Wait: Be the FIRST to get your own BrainSurface Social Profile URL: www.brainsurface.com/yourname/ e.g.

www.brainsurface.com/tariq-farooq/

Here is a summary of the current unbeatable and unmatchable functionality available at BrainSurface for the Oracle & Java community:

- Socialize, Learn, Blog & MicroBlog, Publish, Share, Collaborate & Search Jobs
- Network, Forumize, Manage your Events/Calendar, Share/Post Videos and have fun
- Powerful & Extensible: ALL major collaboration paradigms under one roof for the FIRST time
- 100% integrated with Facebook & Twitter - The ULTIMATE ConnectSpace of the Oracle Community, by the Oracle Community, for the Oracle Community

BrainSurface is 100% standards-based and consists of world-class components and extensions: Nice clean readable URLs, a visually pleasing look and feel, Intuitive & Massive/Extensible functionality and a TRIPLE-BACKUP Data Protection Guarantee at ALL tiers.

Here are a few example URLs for BrainSurface for your viewing pleasure:

http://www.brainsurface.com/arup-nanda/

http://www.brainsurface.com/community/

http://www.brainsurface.com/blogsurface/

http://www.brainsurface.com/knowledgesurface/

http://www.brainsurface.com/forum/installation/

http://www.brainsurface.com/jobsurface/

http://www.brainsurface.com/about/

See you at BrainSurface | The After-Oracle ConnectSpace for the Oracle & Java Community!
1  out of 1 found this valuable. Do you?    
Keyword tags: www.brainsurface.com
Show Last Reply
Showing 3 of 271 threads for this page - view all