Seeking Oracle out of the matrix

Google
 
Web aboutoracle.blogspot.com
Oracle New Articles
Oracle Critical Patches
Oracle jDeveloper News
Oracle Blogs of interest


This blog records my personal experience.
Latest news from the front
               

Thoughts about oracle Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the very best for you and your families for the new year.
Interested to know about a next post? You can suscribe to my RSS feed
HOW TO:

TIP: How to move a datafile from one hard disk to another (quick way)
Saturday, February 24, 2007
If you want a newer, fresher and quicker method to move a datafile from one disk to another here is the way to do it : Make sure the tablespaces are read-only and then


  1. alter tablespace users offline;

  2. copy c:\mydb\users01.dbf e:\mydb\users01.dbf

  3. alter database rename file 'c:\mydb\users01.dbf' to 'e:\mydb\users01.dbf';

  4. alter tablespace users online;



then make your tablespaces read write again,
and you're done :-)

More information : Note:115424.1 on Metalink

Labels: , , ,


posted by Admin @ 9:32 AM   34 comments
add to del.icio.us Digg it! Furl this! add to reddit! add to dzone!
TIP: How to move a datafile from one hard disk to another (safe way)
Thursday, February 22, 2007
I had a test server with 60Gb Hard disk drive. Database was updated thoroughly and space run out quickly. What i did was to install a second hard disk drive and create there another folder to store my moved datafile.
So in order to move c:\mydb\users.dbf to e:\mydb\users.dbf here are the steps to do it safely :


  1. open sql worksheet and connect to the database as sysdba with the sys account,

  2. make sure that all users are out of the database and that no pending transactions are taking place, then run
    shutdown immediate;

  3. execute
    start mount;

  4. copy-paste the datafile you wish to move, to the new location,

  5. execute
    ALTER DATABASE RENAME FILE 'C:\MYDB\USERS.DBF' TO 'E:\MYDB\USERS.DBF';

  6. then execute
    ALTER DATABASE OPEN;


...and you're done.

Easy, isn't it? :)

Labels: , , , , ,


posted by Admin @ 1:28 PM   8 comments
add to del.icio.us Digg it! Furl this! add to reddit! add to dzone!
Get the SSO user id in Oracle Forms and JSP - JSF
Tuesday, February 06, 2007
If you use SSO authentication for your applications and you need to grab the SSO User from your applications here is how you do it:



Oracle Forms



GET_APPLICATION_PROPERTY(SSO_USERID);



jDeveloper project that uses JSP and java beans



request.getHeader("OSSO_SUBSCRIBER")

or

request.getRemoteUser();





jDeveloper that uses Java Server Faces (JSF)

In your AppModuleImpl.java you can get the SSO user by calling



this.getUserPrincipalName();



posted by Admin @ 11:50 AM   3 comments
add to del.icio.us Digg it! Furl this! add to reddit! add to dzone!
About Me

Name: John Galanopoulos
Home: The NeverLands
About Me: A source code wonderer since the early 80s with my first ZX81 by Sinclair, home computer.
See my complete profile
Previous Post
Archives
Links
ΣΚΛΗΡΥΝΣΗ ΚΑΤΑ ΠΛΑΚΑΣ - ΕΓΚΕΦΑΛΟΣ - ΕΓΚΕΦΑΛΟΓΡΑΦΗΜΑ - ΑΝΟΙΑ - ΝΕΥΡΟΛΟΓΟΣ - ΨΥΧΙΑΤΡΟΣ - ΛΟΙΜΩΔΗΣ ΜΟΝΟΠΥΡΗΝΩΣΗ - ΠΑΡΚΙΝΣΟΝ - ΑΓΧΟΣ - ΚΑΤΑΘΛΙΨΗ - ALZHEIMER - EPSTEIN BARR Eurolife
Email notification

Enter your email address and get notified whenever there is a new post:

Delivered by FeedBurner

This website abides by a strict policy : no spam, just posts; and that's a promise.

Powered by

Free Blogger Templates

BLOGGER


Register for a skinnyscore at www.blogskinny.com and increase traffic
Software Blogs -  Blog Catalog Blog Directory

© 2005 Seeking Oracle out of the matrix Template by Isnaini Dot Com