Create tablespace, user, table in oracle 10g

[oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 25 15:19:56 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> CREATE TABLESPACE mytbs DATAFILE '/u01/app/oracle/oradata/ORCL/datafile/mytbs.dbf' SIZE 10M; Tablespace created. SQL> show user USER is "SYS" SQL> SQL> CREATE USER ora1 IDENTIFIED BY ora1 DEFAULT TABLESPACE mytbs; User created. SQL> exit [oracle@localhost ~]$ sqlplus ora1/ora1 ERROR: ORA-01045: user ORA1 lacks CREATE SESSION privilege; logon denied Enter user-name: [oracle@localhost ~]$ sqlplus / as sysdba SQL> GRANT CONNECT TO ora1; Grant succeeded. SQL> connect ora1/ora1 Connected. SQL> show user USER is "ORA1" SQL> CREATE TABLE ora1.table1(col1 number); CREATE TABLE ora1.table1(col1 number) * ERROR at line 1: ORA-01031: insufficient privileges SQL> exit [oracle@localhost ~]$ sqlplus / as sysdba SQL> show user USER is "SYS" SQL> GRANT CREATE TABLE TO ora1; Grant succeeded. SQL> connect ora1/ora1 Connected. SQL> show user USER is "ORA1" SQL> CREATE TABLE ora1.table1(col1 number); CREATE TABLE ora1.table1(col1 number) * ERROR at line 1: ORA-01950: no privileges on tablespace 'MYTBS' SQL>exit [oracle@localhost ~]$ sqlplus sys/oracle as sysdba SQL> show user USER is "SYS" SQL> ALTER USER ora1 QUOTA UNLIMITED ON mytbs; User altered. SQL> connect ora1/ora1 Connected. SQL> CREATE TABLE ora1.table1(col1 number); Table created. SQL>

Oracle Answer

Instructor: Chalit Pojarutsangkul [cpojarut@yahoo.com]

Answer question or choose the best choice. Some of the questions, you can use the EM GUI to simulate and click the SHOW SQL button to see the SQL command.

1. Use dbca to create a database named orcl3 with instance name orcl3. Have the dbca generate scripts which will create database for you. There are many scripts created by the dbca. You need to execute just one file, it will execute the rest and your database will be created. What is the one file you need to execute?

Answer.

The one file that we have to execute is orcl3.sh.

2. In what environment would you execute that file? At the o/s prompt or inside SQL*PLUS?

Answer.

We use o/s prompt to execute that file.

3. You want to make sure next time you startup, the parameter JOB_QUEUE_PROCESSES is set to 15 without affecting current setting of this parameter. What is the SQL command you will issued?

Answer.

1-SQL>CREATE PFILE FROM SPFILE;
2-SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=15 SCOPE=SPFILE;

4. What is the SQL command to create a tablespace MYTBS with the file named /u01/app/mytbs.dbf. The file size should be 10m. The tablespace is locally managed and with automatic space management.

Answer is D.

A. CREATE TABLESPACE mytbs DATAFILE ‘/u01/app/mytbs.dbf’ SIZE 10M EXTENT MANAGEMENT LOCAL AUTOMATIC SEGMENT SPACE MANAGEMENT

B. CREATE TABLESPACE mytbs DATAFILE ‘u01/app/mytbs.dbf’ SIZE 10 LOCAL MANAGEMENT EXTENT AUTOMATIC SEGMENT SPACE MANAGEMENT

C. CREATE TABLESPACE mytbs DATAFILE ‘u01/app/mytbs.dbf’ SIZE 10M EXTENT LOCALLY MANAGED SEGMENT SPACE MANAGEMENT AUTO

D. CREATE TABLESPACE mytbs DATAFILE ‘u01/app/mytbs.dbf’ SIZE 10M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

PHStat2

PHStat2 is software that makes operating Microsoft Excel as distraction-free as possible. As a student studying statistics, you can focus solely on mastering statistics now and not worry about having to become an expert user of Excel at the same time. When combined with the Data Analysis ToolPak add-in included with Microsoft Excel, just about all statistical methods taught in an introductory statistics course can be illustrated in Microsoft Excel.

you can download by link below:
http://rapidshare.com/files/61524131/PhStat2.part1.rar
http://rapidshare.com/files/61525130/PhStat2.part2.rar

or you can search in http://www.filecrop.com/

Format Factory

hey! you want to convert your video to any kind of music or whatever. Format Factory can help you!. All you guy, would be enjoyed it.


you can download here:http://format-factory.en.softonic.com/
Format Factory supports the following formats:
Audio: MP3, OGG, WMA, M4A and WAV.
Image: JPG, BMP, PNG, TIF and ICO
Video: MP4, AVI, 3GP, MPG and FLV

Install Chinese fonts with Ms windowsXP

Install Chinese fonts with Ms windowsXP

1- go to Start menu
2- settings
3- control panel

4- below dialog will appear

5- Select the Regional and Language Option
6- then open or double click on it
7- below dialog will appear
8- then Select the Languages tab
9- then check install files for East Asian languages Normal 0 false false false MicrosoftInternetExplorer4

10- then Click OK.
11- the installation will process copying the file like show with the picture below


12- then It will need the CD Windows Xp to install other file, like show below

13- In this step you must insert the CD Windows XP professional in the CD drive
14- Then Click on OK.
15- Then it will continue the process of copying the file until it finish.
16- Then the system will ask to restart the windows. please click Yes to restart.
----------------------------------------------------------------------------------------

After Restart the windows

* Please process from number 1 to 8 again until you see the dialog below

17- then click on Details

18- the dialog will appear below.

19- Please select CH Chinese(PRC)
20- Click on Add button
21- the dialog will appear

22- Input language:
+ Select the Chinese (PRC).
+ then check Keyboard layout/IME:
+ then choose the
- Chinese(Simplified) – QuangPin, Or
- Chinese(Simplified) – ShuangPin
(We can add both of them)
+ then it look like the picture below:

+ then click on OK button.

+ it will show the dialog look like below

23- then Please click on Language Bar… button

24- the dialog below will appear.

25- please check on Show the  language bar on the desktop.

26- then click on OK button until you close all the application.

* Now if you find it you can change the language that you want to type:
* you can change by select whatever you want:

How to convert from pdf file to word or excel file or other file?

How to convert from pdf file to word or excel file or other file?
To do so make sure that you have install OmniPage application to convert it.
1- Start OmniPage from program menu.

2- Select Classic View or the rest which you want to use.


3- Then Click on Close button if you don’t want to see the guide, if you don’t familiar with it you can choice which you want.

4- Click on Get Page button as show


5- Then it will show the Load Files dialog below, find your pdf file then click on OK button



6- Then Click on Perform OCR button as show below.

It will scan your page and check your spelling of your text and display a dialog that let you to correct then meaning. If you don’t want to correct it Click on Close button

7- Then click on Export Result.


8- It will let you to save it to a kind of file that you want to convert to.


You try it, you get it, good luck.

How to convert from QRP file to pdf or other image file?

Hi sothea,

for your requested, I think this can help you.

The Quick Report it is generated by some programming language like VB or other programing language. And you can not view this file in word, excel or acrobat application, so how can you view this kind of file. The easy answer is that we need the application called SmartQRP to view and covert this file to other format such as pdf, bmp, jpg, emf, wmf file.

where you get this file? So if you don’t have it yet, please go to this link:http://www.torry.net/tools/reports/other/SmartQRP10RC2.exe to download it and save it to wherever you want.

After complete download SmartQRP file, you can install it into your computer.

How to install SmartQRP?
1- Select the SmartQRP file where you just download it.
2- Select on the SmartQRP file then Open or Enter on it.
3- The dialog box show below:

4- Then you follow the instruction of Setup SmartQRP until it finish or Click Next

5- Click Next button

6- Click Install button

It will start to install the SmartQRP then Click on Finish.
So after complete installation, it will automatic create an icon on your desktop computer.

Then Open SmartQRP on your desktop by double click on the icon or right click to open, and it will show the picture below:

Then Click on Open button to open the qrp extension file

Then find the qrp file and open it. It will show as picture below:

Then if you want to save it to pdf, bmp, jpg, emf, or wmf file, just click on the top right button as show on below, then type the name of file that you want and click on Save button.