alit2002

Hi You have to understand Oracle storage. Each table is made up of extents and each extent is made up of oracle blocks - a common block size is 8k. So you have a table with 10 extents (80K). You populate your table with 2 million rows of data and …

You could also try this. Open a command DOS window c:\> set oracle_sid=orcl c:\> sqlplus / as sysdba That should get you in. You can then unlock scott and reset the system password if you don't know what it is. alistair

Hi I guess when you performed the install you created a database? If not then use the Database Configuration Assistant to create the database. If you did create a database at installation time then you would have been prompted to enter a password for SYS and SYSTEM. If you are …

I'm no PL/SQL expert but have you tried a ; at the end of line 2? VARIABLE emp_salary NUMBER; Might help.

[QUOTE=grii_19;593820]jwen ... but i am new to this .... so have no clue on how to login as admisn console ? how to do tht ... can ya elaborate it .. thanks for the help[/QUOTE] Have you created a database? If so you would have specified the SYS and SYSTEM …

Try alter table <table_name> modify (<column_name> <datatype>); or alter table <table_name> add (<column_name> <datatype>); Watch out though. If you have data in the column you cant reduce it's size only increase it. Alistair

Hi I think you need to check out the SQL 'BREAK' command. See below: BREAK ON To produce grouping of items as in a control break report, use the BREAK ON command, in conjunction with the ORDER BY option in the SELECT command. Break on Item skip 2 SQLPLUS will …

Hi If you really want 9i you can download it from here but I think it is just the base release. [url]http://edelivery.oracle.com[/url] Alistair

Hi A tablespace is contained within the database. It is the way oracle sees a file at the O/S level. If you are using 9i connect to the dataabse from the command prompt C:\> sqlplus "/ as sysdba" SQL> Then create your tablespace create tablespace my_data datafile 'c:\oradata\orcl\my_data01.dbf' size 512m …

The new utility is known as expdp to differentiate it from exp, the original export. In this example, we will use Data Pump to export a large table, CASES, about 3GB in size. Data Pump uses file manipulation on the server side to create and read files; hence, directories are …

Hi I have a new Dell Dimension 3100 PC running windows XP Home. I'm having difficulty with the microphone recording level in that it is so quiet you can hardly hear it. The sound drivers are from SigmaTel and are the latest version. I've checked all the sound levels through …

Er guys, SqlPlus 3.3.4.0.0? Isn't this from the days of Oracle 7? I would think we would need to know more about your config before we could really help! client / server, versions of oracle and client, where components are installed etc. Your error suggests that the oracle client components …

Hi I'm running Windows XP Pro. SP3. RDP used to work fine but following the SP3 patch (I think) I noticed that the RDP icon had changed in appearence. When I try and use Remote Desktop it launches and then displays an error box saying "Remote Desktop Connection has encountered …

Take an export of the schema and import it into yours.

Hi At the command line you can type sqlplus /nolog SQLPLUS> connect sys/password as sysdba Hope it helps.

Hi Your script should update the record assuming the ID and name exist. Try a commit after the update to save the change. UPDATE table_one set ID=replace(ID,'&ID','&ID') where Name='&Name'; commit; select * from table_one; -- will show your change Don't perform the update in one sqlplus window and try and …

Delete allows you to rollback or undo your transaction. Truncate doesn't use the rollbacks and the data is gone. Truncate should be quicker than delete if you are deleting all records in a table. Check otn.oracle.com for documentation. Alistair [QUOTE=rambo123;816074]hi, what is the diffrence between delete and truncate command in …

Hi If you have 1.5 years experience then I would have thought that would have been enough to get a job as a junior DBA! If you can't get a job then why not download the latest version of Oracle (11g) and install it and play with the new features. …

I believe in Discoverer Administrator you can restrict the privileges of users so they can't change your report. If they make a change they have to save it under a new name. Might be worth looking into.

Hi Check out the link below, it may help you out. [url]http://download.oracle.com/docs/html/B10268_01/uccalc.htm#1006246[/url] Merry Christmas Alistair

Hi At the command line try something like this c:\> exp system/manager file=myfile.dmp full=y buffer=20000000 log=exp.log This will take a full export of the database (assuming system password is manager) and put all the data into the file called myfile.dmp. DO NOT try and edit this file as it is …

The following SELECT statement will find and display all duplicate rows in a table, except the row with the maximum ROWID. The example uses the dept table: SELECT * FROM dept a WHERE ROWID <> (SELECT MAX(ROWID) FROM dept b WHERE a.deptno = b.deptno AND a.dname = b.dname -- Make …

To access the help utility type the following at the command line C:\> exp hep=y or C:\> imp help=y All the commands you need are there.

Sounds like a good idea to me. Once you have created the lookuptables in this schema you can simply grant select on the table to the other application schemas. It can then be referenced by [icode]select * from schema_name.table_name;[/icode] or you could create a synonym to g=to get rid of …

Hi If you drop a table the index will also be dropped. The trigger and synonym will still exist and if you want to get rid of them you will need to drop these objects as well. Alistair

Things to check: More than one installation of oracle on the server or more than one oracle_home. If so you will have multiple tnsnames.ora files. If this is not the case then try setting TNS_ADMIN to point to the Oracle_home\network\admin directory. Regards Alistair

Have you thought about using Log Miner to view the transactions? It may give you what you need. Alistair

Do you have to have the child table in this format? It would be easier if the income and expenditure were in different columns. You could create two views, one for income and the other for expenditure then the query would be simple. If you can't do it this way …

Have you tried [url]http://otn.oracle.com[/url] and follow the download link. Alistair

Hi I'm the latest newbie to sign up here... I work in the IT industry and specialise in Oracle RDBMS software, installation, upgrades, health checks, tuning etc, you get the picture. Away from IT I'm into astronomy (got a 150mm reflector telescope) and I love playing chess. You will find …

Have you downloaded Oracle software? Then after installation connect to the database create yourself an acount WINDOWS c:\> sqlplus "/as sysdba" UNIX $ sqlplus "/as sysdba" SQL> create user newbie identified by manager default tablespace users temporary tablespace temp; SQL> grant connect,resource to newbie; SQL> connect newbie/manager@my_db SQL> create table …

Hi I have a new Dell Dimension 3100 PC running [URL="http://www.daniweb.com/techtalkforums/thread63792.html#"]windows XP Home[/URL]. When I play a DVD the picture is fine but there is no sound. There are two media players (sonic and windows media player) and they both have the same symptoms. The volume slider is set to …

Hi You don't say which version of Oracle that your using. If the live server has an identical setup to the test server you could simply shut the test database down and copy the files into the identical directories on the live server. You will also need to set the …

Hi The first query you list suggests that a column doesn't exist. Check this by typing SQL> desc books This will give you a list of columns. 2. I don't think the word join should be between customers and orders. A join would be where customers.id = orders.id 3. you …