I cannot start my database using STARTUP in sqlplus.
SQL> STARTUP
ORA-12162: TNS:net service name is incorrectly specified
What maybe wrong here?

and how to get it, tried to use top n function in select statement
it takes only the first record.
itemid   qty

This is probably easy and I'm missing it because I'm a little
sleep-deprived this month, but:
given the following table 'test':
name     group                salary

I try to execute PL/SQL script from a file using the SQLPlus command
shell. But it doesn't seem to execute the script that might be buggy
(despite the fact, I've tested it in the SQLWorkSheet), I removed all
the blank lines that may cause SQLPlus to down..

  We are currently using Oracle DB 9.2.0.5 on Windows 2000 Advanced
Server and we use Oracle's generic connectivity for heterogenous
connections to  a non-oracle source(SQL*Server) to perform DML
operations to and from the foreign system.

We want to create a field F of type varchar(6) for use in one client's
version of our software, and then the same field F of  type varchar(12)
for use in another. What's the best way to go about doing this. Neither
company want to use the alternate size field definition.

We have a ORACLE role with 50 different object privileges grant to it.  Does
there has way to generate a script which I can bring this script to another
database and re-create it?
Thanks.

Has anyone been able to use a bulk collect with a stored procedure that
returns the results to JDBC?  I had to use table%rowtype for a 'select
into' in the stored procedure and it is only visible in the package.

I have some specific questions on migrating a Oracle 8.1.7 database from
AIX to Windows.
I know something very similar has been asked before, but I can't seem to
get some unique recommendations on where to start.

i am trying to extract data out from an oracle server and am having a
tough time with the most basic sql statement. when i run
SELECT distinct tcof.EML_ADDRESS from
test.EML a,

I recently tried to use the view "DBA/Tablespace Map" in TOAD,
but I am not sure how to interpret this screen.
What puzzles me is:
e.g. that we have a tablespace that by

I have the following code in my procedure:
 retval := DBMS_LDAP_UTL.get_group_membership ( my_session,
                                user_handle,
                                DBMS_LDAP_UTL.DIRECT_MEMBERSHIP,

I use both SQL Plus and SQL * Plus work Sheet
I inserted records via SQL Plus and when I run the query
Select * from test works well
But the same query does not produce the result when running work sheet

Hello *.*,
is there a possibility to tune mass deleted on a table, that is linked
to by many other tables using foreign keys. These tables have about
100-200 times more records than it, not null links.

I am in the procees to implement private area to our main webstite on
the internet.
The private zone will allow authorized individual person inside and
outside the country to view his/her own data and transaction