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.

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...

I'm no PL/SQL expert but have you tried a ; at the end of line 2?

VARIABLE emp_salary NUMBER;

Might help.

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...

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.
...

Hi

This could be connected to the version of Discoverer that you're using as there isn't much Oracle software that's certified to work with Windows Vista.

I need to know what version of...

Good luck...

Hi

Saw this on the web, might be worth contacting Progressive. Also you could write to Quantix, Xynomix and Teamsolve. These companies all have Oracle consultants, support desks etc. Who knows...

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...

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';...

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...

Hi

Check out the link below, it may help you out.

http://download.oracle.com/docs/html/B10268_01/uccalc.htm#1006246

Merry Christmas
Alistair

Forgot to mention that in 8i (assuming that you've created a database after installing the binaries) the default passwords are

SYSTEM / MANAGER
SYS / CHANGE_ON_INSTALL

In 9i you are prompted...

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...

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 select *...

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...

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

Yes, it would. It shows that the listener is failing. Can you post the contents of the listener, tnsnames and sqlnet.ora files or email them to me? I will have a look at them.

I will also need...

Okay, go to the oracle_home\network\admin directory and check that you have a listener.ora file and tnsnames.ora file. If not then use the Net Manager utility to configure the listener and start it...

Have you created a database? If so you would have specified the SYS and SYSTEM passwords. If you haven't done this bit then run the Database Configuration Assistant to help you create a database. If...

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

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...

Or use something like this

select sum(decode(fk_incm_id,'1003',amount, 0))+sum(decode(fk_incm_id,'1004',amount, 0))
-sum(decode(fk_incm_id,'1001',amount, 0))+sum(decode(fk_incm_id,'1002',amount,...

I do understand the problem. Is it possible to use pl/sql in a derived field to make the total?

Alistair

My last reply wasn't very clear. If you can't have income and expenditure in different columns then try creating a view for income and one for expense. A simple join on the views would give you the...

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...

Dont forget the final

);

to finish off the statement.
Alistair

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).
...

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...

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...

Have you tried http://otn.oracle.com and follow the download link.

Alistair

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...