tag:blogger.com,1999:blog-5603459235786069906.post3160518481250949523..comments2017-03-18T00:11:20.962-07:00Comments on Thilina's Blogger: Usefull Oracle commandsAnonymoushttp://www.blogger.com/profile/12561824492329016321noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5603459235786069906.post-47322499090876010262007-07-05T22:20:00.000-07:002007-07-05T22:20:00.000-07:00Log into the Oracle prompt------------------------...Log into the Oracle prompt<BR/>---------------------------<BR/>1) Log as oracle user<BR/>2) sqlplus system/password@db_name<BR/><BR/>Describe the table schema<BR/>-------------------------<BR/>1. Log into oracle prompt<BR/>2. Execute desc table_name;Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-37417707744869606572007-06-18T22:35:00.000-07:002007-06-18T22:35:00.000-07:00Usefull oracle guide see...http://www.lc.leidenuni...Usefull oracle guide see...<BR/><BR/>http://www.lc.leidenuniv.nl/awcourse/oracle/nav/docindex.htmAnonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-2145682384365515062007-06-18T21:38:00.000-07:002007-06-18T21:38:00.000-07:00Oracle views see...http://www.psoug.org/reference/...Oracle views see...<BR/><BR/>http://www.psoug.org/reference/views.htmlAnonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-16260775594857202182007-06-18T05:51:00.000-07:002007-06-18T05:51:00.000-07:00If you get "ORA-27123: unable to attach to shared ...If you get "ORA-27123: unable to attach to shared memory segment" <BR/><BR/>ORA-27123: unable to attach to shared memory segment.<BR/>I temporarely increased the shmmax setting for the kernel by executing the following command:<BR/><BR/>$ su - root<BR/># cat /proc/sys/kernel/shmmax<BR/>33554432<BR/># echo `expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax<BR/># cat /proc/sys/kernel/shmmax<BR/>1073741824<BR/>It is recommended to increase the shmmax setting permanently for Oracle. For more information, see Setting Shared Memory.Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.comtag:blogger.com,1999:blog-5603459235786069906.post-25005707951688502792007-06-18T05:31:00.000-07:002007-06-18T05:31:00.000-07:00Database creation procedure as follows;Create the ...Database creation procedure as follows;<BR/><BR/>Create the table space under the Database. Use 'oemapp dbastudio' and create the table space under the created database. <BR/><BR/>Then log into Oracle prompt as follows;<BR/><BR/>sqlplus oracle_username/password@db_name<BR/><BR/>eg: sqlplus system/beyondm@suntel<BR/><BR/>Then create a user with following commands;<BR/><BR/>drop user @db.users.owner.username@ cascade;<BR/>create user @db.users.owner.username@<BR/>identified by @db.users.owner.password@<BR/>default tablespace @db.tablespace.default@<BR/>temporary tablespace @db.tablespace.temporary@;<BR/><BR/>grant connect, resource to @db.users.owner.username@;<BR/>grant query rewrite to @db.users.owner.username@;Anonymoushttps://www.blogger.com/profile/12561824492329016321noreply@blogger.com