Hugo Estrada's House of Wonder

SELECT * FROM USER_TABLES

Short

Select COLUMN_NAME from all_tab_columns where table_name=upper('tableName')

http://forums.oracle.com/forums/thread.jspa?threadID=375977

Yesterday I had the joy of having the Oracle 11g install majorly mislead me. Even though it couldn't really work on my windows computer due to it having a dhcp ip, the installer gave me a "warning" that got buried in their amazingly small viewing area, and it let me continue the install. Even better, by letting me log into the db in SQL*Plus, it totally faked me out into believing that the installation was successful. It was only when I tried to work with it in .net that i started getting the annoying tns not running error.

So I search for to see what the problem is, and there are tons of posts in the oracle forums on this error, everyone with a different problem and solution. I dutifully try the different solutions, I get it to "work" according to the solutions, i.e, I get the hellish service to actually run, and yet it still won't work in .net.

And this is RIGHT AFTER INSTALLATION, WHEN THE DAMN THING SHOULD WORK.

So I decided to uninstall and install again. While installing again, I noticed that I got "warning" telling me in a weak worded way that stuff may happen in dhcp if I go ahead with the installation. The stupid feedback should read: "It WON'T WORK. Install the freaking Microsoft loopback Adapter First."

Fortunately this actually fixed the problem.

I don't know if Oracle just likes to prank developers, or if this is some kind of hazing to join the Oracle crowd. This error message is so common and is triggered by so many things that the desperate posts of people are received with a massive yawn by the regulars who tell you to search through their archives to find the solution.

And I guess that their ridiculously small viewing windows at the prerequisite check of the installer, which one cannot adjust, is their way of stating to the world that Oracle is a totally back-end development shop? Do they put interns to create the install GUIs?

I am still angry, and the best part of this is that I actually rested and went to sleep before posting this.

You initialize it like this:

var membership = Membership.Providers["orclmembershipProvider"];
var validated = membership.ValidateUser(user, password);

A bit different than MS's provider. The name of the provider that you give is the one that you put in the web.config tags.

Answer:

grant create session to ;

I had to hunt for this one as well. Maybe the word ACCESS is used for something else.

http://thomas.eibner.dk/oracle/old/

Answer:

grant unlimited tablespace to ;

It took me a while to find this. Unfortunately I closed the window too quickly so I cannot give the link to the place where I found this entry.

Hugo

The Answer:

To see current working directory within Sql*Plus command line:
host echo %CD%

To change directories:
host cd c:\go\toyour\directory

Long story:
the command 'host' in sql*plus let's you perform calls to the shell/command line of the operating system that you are using. In this case I am using windows, so instead of using the handy pwd, I had to use the clunky echo %CD%. Style aside, it works.

Thanks, shoover at stackoverflow for the quick answer to this question :)

http://stackoverflow.com/questions/1840816/sql-plus-how-to-change-direct...