text:
Misconduct investigation finds Kolby Granville violated Tempe code of conduct. Will it get him booted from council?
The Tempe City Council hired an attorney to do a code-of-conduct investigation after former Tempe Prep students accused Kolby Granville of misconduct.
Misconduct investigation finds Kolby Granville violated Tempe code of conduct. Will it get him booted from council? The Tempe City Council hired an attorney to do a code-of-conduct investigation after former Tempe Prep students accused Kolby Granville of misconduct. Check out this story on azcentral.com: https://www.azcentral.com/story/news/local/tempe/2019/03/01/tempe-releases-code-of-conduct-investigation-into-councilman-kolby-granville/3020489002/
People gather at the City Council meeting at the Municipal Building on Feb. 8, 2018, in Tempe. Patrick Breen/The Republic
Tempe City Council and embattled Councilman Kolby Granville
Tempe Councilman Kolby Granville walks before the start of the Tempe City Council meeting at the Tempe Municipal Building on Feb. 8, 2018, in Tempe. Patrick Breen/The Republic
Tempe Councilman Kolby Granville speaks during a City Council meeting at the Tempe Municipal Building on Feb. 8, 2018, in Tempe. Patrick Breen/The Republic
Tempe Councilman Kolby Granville (center) bows his head during a moment of silence at the Tempe Municipal Building on Feb. 8, 2018, in Tempe. Patrick Breen/The Republic
Tempe Councilman Kolby Granville waits for the start of the City Council meeting at the Tempe Municipal Building on Feb. 8, 2018, in Tempe. Patrick Breen/The Republic
Tempe Councilman Kolby Granville gets to his chair before the start of the City Council meeting at the Tempe Municipal Building on Feb. 8, 2018, in Tempe. Patrick Breen/The Republic
People gather at the City Council meeting at the Municipal Building on Feb. 8, 2018, in Tempe.
Paulina Pineda and Anne Ryman, Arizona Republic Published 1:33 p.m. MT March 1, 2019 | Updated 7:02 p.m. MT March 1, 2019
Tempe City Councilman Kolby Granville appears to have violated the city's code-of-conduct based on misconduct allegations made by three women, an independent investigator hired by the city said.
Attorney Sarah Barnes wrote in findings obtained by The Arizona Republic that the allegations are "more probably true than not." Granville's interactions with the three women "constitute abusive attitude, language, behavior and/or conduct" and his behavior resulted in "physical harm, or the threat thereof," she wrote.
The investigator wrote that formal censure is currently the maximum sanction but that "the maximum sanction could be changed to removal from office in the near future."
The Tempe City Council is expected to discuss the allegations against the 44-year-old Granville later this month.
Among the new findings in the report prepared by Barnes:
Granville in 2014 is accused of sticking his hand down the pants of one of the women. He "digitally penetrated her vagina with his fingers," the investigator wrote. The woman said she told Granville to stop, but he didn't remove his hand. Granville denied the allegation, telling the investigator "Yeah, I'm sure that didn't happen," according to a copy of his interview transcript released Friday.
A Phoenix police detective who investigated allegations made by the three woman in 2018 for possible criminal charges said she believed the women were telling the truth.Their emails and other information corroborated their stories, she said.
The detective said thethree women were "very insecure and vulnerable" and Granville chose them specifically because they would be easy to manipulate. The detective said she didn't recommend prosecution because the women declined to prosecute, and Granville refused to talk to police.
Granville, during an interview for the independent investigation, came across as "evasive and deceptive," the report said. He vacillated between remembering specific details and not remembering other aspects.
The report said the councilman's only blanket denial was that he did not provide alcohol to the underage women. He often responded to questions with "I don't recall that happening" or "that does not make sense," instead of unambiguous denials.
Granville told the investigator that Vice Mayor Lauren Kuby asked him in private on several occasions to resign over the allegations. She reportedly told him at an elementary-school spelling bee the council was attending that he should leave. "She was like, 'I don't think you should be here. I think it's inappropriate for you to be around children,'" Granville told the investigator.
After the police investigation began, the father of an eighth-grade student at the school where Granville used to work told police his daughter received a Facebook friend request and an Instagram request from Granville, which his daughter thought was "weird." She didn't accept and never had any contact with Granville. Granville told the investigator he has no recollection of this.
Documents released by the city on Friday under the Arizona Public Records Law didn't reveal the investigator's recommendations on whether Granville violated city code-of-conduct policies; those portions were redacted by the city.
The Republic was able to obtain an unredacted copy of the recommendations.
Granville did not return a call, email and text message seeking comment on Friday.
The two-term councilman has denied wrongdoing.
"I deny the allegations because I have no memory of them happening, and because if they had happened as described, I would have a memory of them happening. I deny the allegations because I would not have done the things as described because they are out of character," Granville wrote in his response to the investigator's report.
Misconduct allegations surface in late 2017
Tempe Councilman Kolby Granville waits for the start of the City Council meeting at the Tempe Municipal Building on Feb. 8, 2018, in Tempe. (Photo: Patrick Breen/The Republic)
Granville was fired from his teaching job at Tempe Preparatory Academy in December 2017 after two former students alleged he gave them alcohol when they were under 21 and one said he made unwanted sexual advances. A third woman filed a complaint the next month and alleged Granville made unwanted advances toward her shortly after she had graduated from Tempe Prep. The women were not in Granville's classes while at the school.
Granville was never charged. A Phoenix police investigation, initiated at Tempe's request, was closed in March 2018 because the victims would not aid prosecution, police said.
After the police investigation was closed, the Tempe City Council hired Barnes for the separate council code-of-conduct investigation into the allegations.
First complaint: Underage alcohol
Tempe Prep launched an investigation in late November 2017 after a former student complained that Granville provided her with alcohol on at least four occasions while she was underage, including once in September 2016 when they spent the night in the same room at the Luxor hotel and casino in Las Vegas.
Granville told The Republic in a previous interview he was in a consensual relationship with the 2015 Tempe Prep graduate, who he said was never a student in any of his classes. He denies providing her with alcohol when she was under 21.
"We went out once and then, maybe a year later, started dating. We dated six months, and it didn't work out and I broke it off," he told The Republic.
Granville told the independent investigator that he asked the young woman to keep their relationship a secret because he thought it could get him fired and because his council colleagues would try to use it as "political fodder."
"Same reason you can't be a Communist in the 1950s. Same reason you can't be gay in the 1980s. My life exists the way it exists now because I was dating her," he said. "Because something can be permissible to do, but not socially acceptable to do."
Second complaint: He 'insisted on getting me drinks even though I was underage'
Two days after the first complaint was filed, school officials said they received a second complaint from another former student, who said in an email she was "close friends" with the woman who made the first complaint.
The former student said Granville was never her teacher, but she knew him from attending the school.
The 2013 Tempe Prep graduate wrote that she "reconnected" with Granville in the summer of 2014, and he bought alcohol for her, even though she was underage, and flirted with her.
In winter 2014, her email complaint said, Granville invited her to go to San Francisco with him around New Year's Eve. He offered to pay for travel and expenses.
She agreed. Several weeks before the trip, he invited her to his house, where he gave her "multiple gin and cranberry cocktails," she wrote in the email to school officials.
She told him she was too drunk to drive and asked if she could sleep on his couch.
"Mr. Granville remarked that I should instead sleep in his bed since it was warmer and more comfortable," she wrote in the email.
Once in the bed, he moved closer to her and stuck a hand down her pants, and "digitally penetrated her vagina with his fingers," the investigator wrote in the city's investigation.
She said she told him to stop, but he didn't remove his hand.
She got out of bed, ran to her car and cried. Then she drove home.
The former student wrote that Granville asked her the next day if she still wanted to go to San Francisco, telling her, "It was unlikely I would ever get this chance again and I should take it."
She told school officials she was persuaded to go with him to San Francisco and "no more advances were made after the trip."
Granville said he was friends with the woman and her parents, but he has no recollection of the events she alleged. In an interview with the independent investigator, he denied penetrating the woman.
Third complaint: 'Violated, intimidated, uncomfortable'
A third woman came forward with a complaint in January 2018 to the Arizona State Board for Charter Schools, detailing incidents with Granville that "made me feel violated, intimidated and uncomfortable."
She graduated from Tempe Prep in 2013, though she never had a class with Granville. She said she was introduced to him in August 2013 by a teacher at the school because she was planning a trip to Europe. The teacher suggested the young woman speak with Granville as he had experience traveling abroad, according to the complaint.
The woman alleges Granville invited her to his house in September 2013 to eat ice cream and discuss her upcoming travel. She accepted, and the two went to the roof to talk. After several minutes of conversation, he asked her to lay her head on his chest, the complaint said.
"When I appeared to take too long to think about it, he said it wasn't a big deal and pulled me closer," she said in the complaint. He then began to talk "in detail" about his sexual experiences, which she said made her feel uncomfortable.
He kept taking her hand and putting it on his chest; she would pull it away and he would put it back, the complaint alleges.
When she told Granville she had to leave, he asked her if she was 18, according to the complaint. She told him she wasn't. She was 17 at the time.
"Well that shoots down my goodnight kiss idea," she alleges Granville said in reply.
Two months later, she said she met with Granville again at his home to return travel books she had borrowed. At this point, she had turned 18.
Granville opened the door and told her to put the books on the table. After she did, she noticed he had closed the door and moved closer to her, according to the complaint.
He kissed her without consent, she alleges.
She said she wanted to leave. But she said he moved in front of the door and told her he did not want her to leave yet. He put his hands on her upper arm while slightly touching her chest and kissed her again without her consent, according to the complaint.
"Just the look in his eyes made me feel really scared," she said to The Republic in a previous interview.
She said she told him again that she thought she should leave and made it clear she was uncomfortable.
Her complaint says Granville replied that "maybe I should leave before we both 'do something we regret.'"
Granville told the independent investigator he remembers the woman coming over to his house where they went onto the roof. He asked her how old she was.
When she told him she was 17, he asked her to leave and "she was pretty upset and I said, 'Look, if you want to try to get together as friends in a year or two, I'm happy to do that, but you got to go,' and so that was that," he said, according to the interview transcript.
Granville denied that the woman returned to his home after her trip abroad.
"I'm sure that did not happen," he told the investigator.
Report now in council's hands
Now that the investigation is complete, the council will decide the next steps.
The council could do nothing, seek to censure Granville or seek to remove him from office.
Tempe voters in November gave the City Council the power to oust a member for misconduct. It's unclear if the new rules could be applied to Granville should that be warranted.
Vice Mayor Lauren Kuby told The Republic that the council will discuss the allegations during a March 21 study session, where the public will be invited to speak.
"The sexual-assault allegations are deeply disturbing and serious," she said. "Ultimately, what we do will be dependent on what residents are telling us. I have opinions on this, and I have previously publicly asked him to resign, but the public needs to weigh in on these allegations."
Kuby said she is seeking clarification from the city attorney on what the city's next steps are legally.
She had previously said the charter change could not be applied retroactively to Granville, but now says because the council was unaware of many of the details released in the documents, she believes the new rules can be applied.
"This is the first time the council has seen these allegations. This is all new," she said. "I just want to keep an open mind."
Other council members could not be reached or declined comment Friday.
During an interview with the investigator, Granville acknowledged that he could be removed from the council over the allegations. Asked if he believes the new rules would be applied retroactively to him, he said he thinks his council colleagues would try.
"I think given how popular I generally am among Tempe residents, I think that they're going to have to do a (weight) on how much they want to get rid of me versus how much the fallout is worth," he said in a transcript of the interview.
Granville told the city investigator that he didn't think he had broken the city's code-of-conduct rules in this case or in two others where he was formally reprimanded. The two past censures, both in 2017, were for Granville's language, in one case with an employee and another in a remark about a constituent on social media.
Granville was first elected to the Tempe City Council in 2012 and is known for being active in neighborhood associations. He isn't shy about voting contrary to his colleagues on the council. He was the only council member to vote against a controversial $21 million tax break to bring a hotel and conference center to Tempe.
His term expires in 2020, and he has previously said he has no plans to seek re-election.
Asked if he intended to resign, as Kuby and Councilman Randy Keating have called for, Granville said he would like to but believed it was his duty to continue serving.
"Because 15,000 people voted for me to do a job and I believe I should do that job. And so, it's a horrible, miserable, terrible job where I put up with stuff like this, but it's really not about what I want to do," he said.
READ THE REPORTS FROM THE GRANVILLE MISCONDUCT INQUIRY:
Kolby Granville interview with attorney Sarah Barnes
Kolby Granville response to code-of-conduct allegations
Attorney Sarah Barnes' memo on Granville findings and recommendations
Attorney Sarah Barnes' 1st Feb. 2019 memo to city attorney Judi Baumann
Attorney Sarah Barnes' 2nd Feb. 2019 memo to city attorney Judi Baumann
Reach reporter Paulina Pineda at paulina.pineda@azcentral.com or 602-444-8130. Follow her on Twitter: @paulinapineda22
Reach reporter Anne Ryman at anne.ryman@arizonarepublic.com or 602-444-8072. Follow her on Twitter at @anneryman.
Support local journalism.Subscribe to azcentral.com today.
Read or Share this story: https://www.azcentral.com/story/news/local/tempe/2019/03/01/tempe-releases-code-of-conduct-investigation-into-councilman-kolby-granville/3020489002/
High-profile homeless camp near downtown disbanded
Missing Idaho kids: New details on Chandler killing of Charles Vallow
Construction begins on latest high-end Phoenix apartment complex
Purple haze: Marijuana farm causes purple glow over Snowflake
2 Phoenix City Council members take a jab at Garcia in video
Ducey seeks to distinguish AZ as model for others in State of the State address


Exterior Front Porch Ideas to Impress Your Guests Covering. Designs. Before.
Front porch will welcome visitors who visit your house; that is why we share front porch ideas to help you make your frontal porch looks impressive. When decorating your frontal porch, think about lots of flowers. Flowers make your front porch looks more beautiful. Line the steps of your front porch with colorful blooms. Doing it will make the steps of front porch look adorable, a perfect place to read interesting books.
Between your gorgeous front porch decorations you must put one bright colored bench. Your bright colored bench is going to be a nice seat but you can also use the bench to serve lemonade to guests or to put potted plants or display the other accessories or decorations for your frontal porch. If you want to display your potted flowers, you better display the potted flowers in creative way like our front porch ideas using stacked pots.
Front porch will be a nice place to welcome your guests before they get into your house. Try our frontal porch ideas here that perfect your frontal porch.
Tags: curtain. colonial. chair. summer. ideas. winter.


The Gaston Lincoln Cleveland Continuum of Care (CoC) is a regional tri-county collaboration of local government, nonprofit and community organizations designed to promote community-wide commitment to identify and address issues related to homelessness. The fundamental mission is to aid homeless individuals and families by providing access to available services and resources that lead to long-term permanent housing and self-sufficiency.
Want to learn more about the Continuum of Care Program?
Continuum of Care HUD Exchange, an informational and educational webpage provided by the U.S. Department of Housing and Urban Development, has a Continuum of Care Resource Page that offers training materials and resources, news and announcements, program reports, mailing list, and more!
COC Toolkit The Continuum of Care Toolkit provides resources and guidance to assist Continuum of Care (CoC) Lead Agencies, CoC Collaborative Applicants, and grant recipients and subrecipients to meet the specific requirements for which they are responsible.
2-1-1 Referral Offered through the United Way of Gaston County and available 24 hours a day, the Gaston County 2-1-1 Information Referral Service offers confidential referrals to persons in need of various services.
The Gaston Lincoln Cleveland Continuum of Care participates in Continuum of Care Notice of Funding Availability (NOFA) and Emergency Solutions Grant (ESG) funding opportunities. Participating service provider member agencies apply through their Continuum of Care. Categories of funding include transitional housing, permanent supportive housing, rapid re-housing, supportive services, and HMIS projects.
Annually the U.S. Department of Housing and Urban Development offers a competitive grant award, Notice of Funding Availability (NOFA) FY 2018 Continuum of Care Competition Resources and Updates.
The most effective way to have a greater community impact upon homelessness is through diverse public dialogue and advocacy. It all starts with involvement. Join us in this effort, and contact a representative today!


text:
Morocco Articles | Telegraph Travel
Move over Marrakesh - the secret Morocco where the cool set go for autumn sun
"Chefchaouen's charm lies in the very lack of things to do" Credit: AP
Tara Stevens, Travel writer
11 August 2016 • 11:39am
Tara Stevens
There is a side of Morocco less travelled: the secret, north-west tip of the country that has long been overshadowed by the more exotic allure of the Sahara in the south and mysterious imperial cities of Fez and Marrakesh.
Here, where the mainland stretches out toward Gibraltar and the Rif Mountains ripple along Morocco's Mediterranean coast, lies the country's very own Riviera – a postcard-perfect landscape of rolling ochre hills, deep green reservoirs and verdant valleys busting out all over with hibiscus and frilly pink oleanders against a cobalt blue sky.
Travelling from Fez to Tangier, you'll find a route dotted with useful stops that take in a spot of culture, a couple of beaches, traditional markets and boutique shopping, good food and characterful hotels, providing just enough to stimulate the senses without sending you home exhausted.
Chefchaouen was painted blue, a colour which represents heaven, when Jewish immigrants arrived in the Thirties
At its heart is Chefchaouen (about three hours' drive from Fez), a delightful little hill town that has long been a must-do on the backpacker's circuit thanks to the easy availability of kif – the light and fuzzy marijuana that grows abundantly in surrounding hills, and which might account for its chilled-out nature. Of late, however, a rather more sophisticated traveller has started to show up, curious about this mythic tangle of blue-washed streets that tumble between the two horned peaks giving the town its name.
Before the Rif wars in the Twenties when the little town fell under the watch of the Spanish protectorate, it had been painted green, the colour of Islam, but when a wave of Jewish immigrants arrived in the Thirties they switched to blue, representing heaven, and it has remained so ever since.
Today you'll find civic pride bursting from every hairpin bend, where the teals, blues and turquoises contrast with vines and creepers shading the lanes, and life ambles by at donkey pace. It's a brilliant base for hiking in the Talassemtane National Park, but its real charm lies in the very lack of things to do.
You can poke around the souks in search of artisan goodies – hand-chiselled terracotta tableware is beautiful in its simplicity, and hand-woven wool carpets are cheaper than anything you'll find in the bigger cities – or sip sweet mint tea on the Place Uta el-Hammam, dominated by a 500-year-old citadel, and watch the world go by.
"Teals, blues and turquoises contrast with vines and creepers shading the lanes, and life ambles by at donkey pace" Credit: ap
It's a good place to eat, too, with Casa Hassan leading the way for Berber classics such as chicken, olive and preserved lemon tagine, while simple street food stands simmer fava bean soup over burning wood, coaxing out a smoky nuance that's beyond delicious.
While there's nothing that could conceivably be described as fine dining, there is the Auberge Dardara just a short drive out of town, and it also happens to be the best place to stay. Set within gardens of fruit and olive trees that surround a pretty pool, it's perfection for dining alfresco on local goat's cheese flecked with herbs; rabbit and rosemary tagine; and almond tart. If you want to stay in town, Dar Mounir (Zankat Kadi Alami Hay Souika, 00212 539 988 253) is one of the nicest boutique guesthouses.
The best hotels in Tangier
A 90-minute drive through a gently winding valley down to the Mediterranean lands you in the handsome, former Spanish enclave of Tétouan. Having retained its easy whitewashed charm, and an unexpected amount of culture, it is a good place to hole up in for a couple of days for some light exploration.
Enclosed within five kilometres of ramparts, the old medina was awarded World Heritage Site status by Unesco in 1997. It was always commonly viewed as a gateway between Morocco and Andalusia and frequently feels more Spanish than Arabic, particularly in terms of its laid-back atmosphere, outward-looking architecture and a penchant for lining the pavements with planters full of vermilion geraniums.
Spend a morning mooching about the cobbled streets of the Mellah – the old Jewish quarter, once known for its seamstresses, now taken over by tailors and goldsmiths – before dropping in to the Escuela de Artes y Oficios (Bab el Okla), where you can see skilled craftsmen honing traditional techniques such as intricate, hand-cut zellige (mosaic tiles), carved wood and plaster, and weaving, before breaking for a seafood lunch at the Esquina de Pescado (43 Calle Chakib Arsalan).
Toffee apples for sale in a Chefchaouen side-street Credit: AP
In the bald heat of the afternoon, seek refuge among an impressive collection of mainly Moroccan works at the Centro de Arte Moderno (Avenue Al Massira, 00212 539 718 946), which now occupies the city's former train station, a magnificent building that once connected it to the still Spanish-governed town of Ceuta.
Balmy summer evenings bring locals out in droves to promenade along wide avenues, and there's nowhere more fun for a drink and dinner than in the eclectic courtyard dining room at El Reducto.
This former home of grand vizier Abdelkrim el Abdak, who commissioned tiled walls and a wraparound balcony over the courtyard, has been transformed by the effervescent Ruth, who has added crushed-velvet banquettes, glittering chandeliers and exuberant vases of roses. Her fabulous hosting skills have likewise ensured it remains a favourite among regulars, who come to eat, gossip and sip Moroccan wine long into the night. Then sleep it off a minute away at the serenely minimal Blanco Riad.
Feeling the heat? Retreat to a cafe to sip sweet mint tea Credit: AP
A half-hour drive away is the increasingly glitzy resort of Tamouda Bay, not so much Puerto Banús as St Barth's, with its influx of big-name hotel brands. A Banyan Tree is due to open there at the end of this summer and the Ritz-Carlton is hot on its heels. So good, so swanky – but it is lovely and more down to earth a bit further south at the cheery seaside resort of M'diq, with its long swathe of seashell-scattered beach, pristine water and a blue-and-white-trimmed seafront lined with ice-cream parlours.
All along the shore, plastic sit-up chairs shaded by fringed parasols that could be straight out of the Fifties can be rented for under a fiver. There's no hassle, either: young men paddling in the shallows respectfully avert their eyes from ladies and play chase with younger brothers and sisters. It couldn't be further from the madness of the souks and provides a delightfully old-fashioned day at the seaside – with reliable weather.
After a couple of days' R&R, continue on to the grittier charms of Tangier. Beloved by artists, writers and poets for its spectacular light and wayward lifestyle, it's always been good at reinvention and in the 21st century this is a city on the up. Some whisper that it may one day eclipse Marrakesh.
Winter sun seeker: where to go in November
But despite all the building going on in the new town, the fancying-up of the front and the promise of a luxury new marina, Tangier is still at heart a little village on a hill overlooking the sea. There are great places to stay here now too, such as the Nord Pinus and La Maison de Tanger, and the more established Villa Josephine and La Tangerina.
Touts still spot a tourist from a hundred paces, which can be overwhelming, but mooch with confidence and you'll be surprised how quickly unwanted attention drops off. A firm but polite "la, shukran" – meaning "no, thanks" – will do the rest and enable you to explore the souks in relative peace. There are some great finds here, ranging from hand-stitched leather and hand-woven bed linens to precious antiques at Boutique Majid.
How to visit the real Morocco with children
Top 10: best riad hotels in Marrakech
Alternatively, head up the hill to the elegant and peaceful Kasbah, where you'll find the city's best hotels, restaurants and increasingly a handful of home-grown boutiques. This is a place that still celebrates craftsmanship and ideas. Starbucks, Zara and Topshop have yet to penetrate these ramparts.
Instead you'll find places with depth and substance, like the historic Café Baba (Rue Zaitouni) for Arabic coffee brewed in copper pots, Las Chicas for contemporary homewares, Topolina for flamboyant kaftans and Laure Welfling (3 Place de la Kasbah) for bejewelled cocktail dresses and pom-pom slippers.
"A firm but polite "la, shukran" – meaning "no, thanks" – will enable you to explore the souks in relative peace" Credit: AP
Lunch must be at the iconic Saveur de Poisson (2 Escalier Waller), where for just €18 (£15) you will be treated to hot bread, olives and harissa, prawns bubbling in garlic, and catch of the day grilled over a wood fire, platters of fruit and sweet couscous, washed down with seasonal fruit juices. There's no wine – it's not that kind of place – but it's a proper Moroccan haunt with more soul than anywhere in town.
Come the evening, put your glad rags on and head to El Morocco Club for cocktails before dinner. This has always been the most glamorous part of town – scene of Barbara Hutton's wild rooftop parties and A-list high jinks – and although her house is now privately owned, you can channel the vibe over dinner on the roof of the Salon Bleu at Dar Nour while looking across the straits to the twinkling lights of Tarifa.
Who knows, this might just be the Moroccan odyssey you always dreamt of.
Autumn is ideal because it's not too hot, but is still warm enough for swimming. It's also when the cultural calendar goes into full swing with the Tangier Film Festival, September 20-24, and the Tangier Jazz Festival, September 22-25.
Air Arabia offers direct flights to Tangier (three hours) from London Gatwick twice a week (Tuesday and Saturday). Ryanair offers direct flights to Fez from London Stansted twice a week (Wednesday and Sunday). See directferries.co.uk for details of ferry crossings (one hour) to Tangier from Tarifa in Spain.
"There are some great finds in Chefchaouen's markets, ranging from hand-stitched leather and hand-woven bed linens to precious antiques" Credit: AP
Hiring a car and driver for a few days is a luxury that's still affordable in Morocco; you can book tours through plan-it-morocco.com, and its reliable, English-speaking drivers charge from around £135 per day, based on a five-day trip.
For self-drive car hire, Avis and Europcar both have concessions at Fez and Tangier airports. Driving in Morocco is on the right, and road conditions in this region are generally good with a low volume of traffic. There are lots of police stops, so be aware of speed limits.
The north is not as conservative as Fez, but do cover up, with loose-fitting cotton clothes, mid-length shorts or skirts and a light scarf to cover shoulders and tops of arms. The sun is deceptively strong even in the winter so wear sunscreen – and take something warm for evenings in the mountains.
Where to stay for a budget break in Marrakech, including historic houses and romantic riads
The most romantic hotels in Marrakech, from seductive spas to ravishing riads
The 10 best boutique hotels in Marrakech, from designer riads to palatial good looks
Secret corners of Morocco to discover in 2020
18 amazing places to eat in Marrakech, from riads to rooftops
Morocco latest
Where to shop in Marrakech, from historic souks to modern boutiques
The best things to see and do in Marrakech, from specialised souqs to colourful gardens
12 fabulous bars in Marrakech, from candlelit rooftops to moody speakeasies
09 Jun 2017, 12:30pm
Why you must visit Essaouira, the laid-back alternative to Marrakesh
36 Hours In...Marrakech
Marrakech: getting there
09 Oct 2015, 12:00am
Airbnb owners in Morocco face fines if guests are unmarried
Top 5 European city breaks for families October half-term 2015
October half-term sun: where to find the best deals
Terror threat in Morocco increases
The best desert holidays and tours
Scene of disarray on Moroccan plane after cabin crew 'dispute'
Olympic rower Katherine Grainger tries watersports in Essaouira
Essaouira: Morocco's hip town on the coast
Matthew Williamson's Marrakesh: My Kind of Town
Fes, Morocco: A flavour of the nation
Walking in Morocco: in the footsteps of giants
29 Dec 2014, 12:00am
20 destinations for 2015: Essaouira, Morocco

redpajama_set_name: RedPajamaCommonCrawl


text:
Melody Transcatheter Artificial Valve Finally Gets Go Ahead in US
Medgadget Editors Cardiac Surgery, Cardiology
The FDA is making Medtronic very proud by awarding the company the first US regulatory approval for a transcatheter cardiac valve replacement. The Melody system is designed to be an alternative option to open heart surgery, and it will now be indicated for peds and adults with congenital heart disease who have dysfunctional right ventricular outflow tract conduits. The Melody Transcatheter Pulmonary Valve and Ensemble Delivery System have received European approval back in 2006. We've been covering this system for the last four years and we are honestly happy to see it's finally making the debut to the cardiac market.
From a statement by the FDA:
Clinical studies of 99 participants in the United States and 68 participants in Europe showed that the device improved function of the heart, and the majority of participants have noted improvements in their clinical symptoms. The device showed similar, limited durability compared with existing alternative treatments; 21 percent of U.S. participants experienced a stent fracture, a rate consistent with stent fractures reported for the bare metal stents presently used to treat congenital heart defects of the pulmonary valve.
As a condition of the FDA's approval, the system's manufacturer, Medtronic Inc. of Minneapolis, will conduct two post-approval studies to assess long-term risks and benefits as well as to evaluate the physician specialization needed to perform the implantation procedure, also called generalizability. One study will continue to follow 150 participants from the initial clinical trial for five years, and the second study will enroll more than 100 new participants to be evaluated over five years, in order to evaluate and assess the training program. Safety and benefit assessments will be part of both studies. The FDA also requires that Medtronic maintain a database of Melody recipients.
Here's a video of an implanted Melody valve in action:
Press releases: FDA Approves First Percutaneous Heart Valve…; Medtronic Receives FDA Approval for First Replacement Heart Valve Implanted Without Surgery…
Flashbacks: Melody Transcatheter Cardiac Valve Replacement Shows Good Results in Children; Medtronic's Melody Transcatheter Pulmonary Valve on Track for Approval; Melody Transcatheter Pulmonary Valve Still Being Tested in the US; The Melody Transcatheter Pulmonary Valve


When you live in a city that has below freezing temperatures during a long winter, you get super excited about going on a vacation to one of the most amazing countries in Africa – G h a n a! In my previous post I highlighted some of the amazing places I visited. I used to live in Ghana for two years, but funny enough, there are still certain spots I've never been to! Isn't it funny how that happens sometimes? Well, this post is all about my swimsuits that I rocked this trip. It's safe to say I was a bit daring with these styles, but in 84 – 93 weather, you can literally rock whatever you want. Let your style define who you are!
La Villa Boutique Hotel in Osu. If you haven't noticed I love this spot! My friend introduced me to this place and I'm so glad he did. It's such a relaxing, tropical vibe. Upstairs there is the cutest bar I've ever seen. The art decor was vintage, antique and all around stunning. Within seconds I asked my friend to snap some photos of me before the bartender came back to start his shift. You know I don't miss a good photo opp! This bathing suit is sold only in store at H&M. They have some really cute swimwear! Check them out.


text:
52 Faces of Community: Jeff Cullipher
By Holly Desrosier
Jeff Cullipher is a recovery team leader at a pulp mill by trade and a volunteer firefighter and animal advocate by choice. No matter which task he's undertaking, he always gives it everything he's got.
"I enjoy doing the things for the community—the involvement with the community, making sure the community is safe and at Bangert, making sure the kids are safe," he said.
Jeff was born in Washington, D.C. and moved to North Carolina at age four. He lived in the town of Rover ("If you blink your eyes, you're through it") right outside of Plymouth. After graduating, he joined the Army for six years. He moved to Trent Woods in 1984 to be near his parents, both of whom worked for Weyerhaeuser. He worked at the Chrysler dealership for a while before taking over as the maintenance manager at the New Bern Mall. In 1989, he began working at International Paper, which bought out Weyerhaeuser's pulp mills a few years ago.
"I am what they call a recovery team leader," explained Jeff. "I make electricity by burning liquor. That's a whole unique process in itself."
That same year, he began volunteering for the West of New Bern Fire Department. He is now the traffic sergeant and fire prevention coordinator. As traffic sergeant, he directs traffic at wreck scenes to ensure the safety of his crew and community members. He has witnessed many tragedies during his time there, many of which could have been avoided with safe driving.
"You run into all kinds of stuff," he said. "Car wrecks with kids involved; parents pleading 'save my child.' And us older guys—don't think it doesn't bother us, because it does."
He admitted that it can be a tough job for anyone who has feelings. In the case of serious incidents, the fire department has critical stress debriefings and brings in chaplains to help everyone cope with what happened. Even with the emotional hardships they encounter, Jeff knows it's his calling to help people.
"I've had my share in my 30 years, but I still get up in the middle of the night and go," he said. "My wife says, 'why don't you slow down?' I can't do it. I can be dead tired, and if a call comes in, I'm gone."
The department's fire district is approximately 25 square miles, so they take their role seriously in keeping Craven County residents safe. Jeff drives the services truck that carries the fluids whenever they respond to a structure fire.
"Living just down the road, nine times out of 10 if an engine rolls out of here, I'm driving the engine," said Jeff. "And if I need to, I'll put the gear on and still fight fire."
As the fire prevention coordinator, he helps present fire prevention programs for students at Garber Preschool, Bangert Elementary and other local schools. For Fire Prevention Month each October, he and other volunteers let students look in the firetruck and talk about "stop, drop and roll," smoke detectors and implementing fire plans at home with their families. He also helps with open houses at the fire department on Halloween.
"We started doing what we call an open house safe house," said Jeff. "We have fire prevention materials out for the families. We cook hot dogs and have candy and a bouncy house for the kids because we want a safe place. We also have a hayride. Just an all-around good time."
If anyone within the fire district has a question or problem, Jeff and the crew are more than happy to take calls or visit people's homes to make sure fire alarms are working. While they don't typically install smoke detectors in homes, they have made exceptions for elderly residents who are incapable of doing so on their own. Jeff said they never want to see someone lose their home, so the best option is to call them if there is any issue.
Another important piece of advice he hopes to circulate is that smoke detectors are not good for life. He and other firefighters were called to one woman's home because her smoke detectors kept making a chirping sound. They inspected them and discovered they were 15 years old.
"A lot of people don't understand," said Jeff. "You're supposed to check it twice a year but can do it more than that. The life expectancy of a smoke detector is only five to eight years. And then your carbon monoxide detectors are three to five years. Carbon monoxide is the silent killer because you can't smell it, can't touch it or anything like that."
He added that if households use gas of any kind, they should have a carbon monoxide detector. He and his department have encountered many fires that could have easily be prevented if homeowners took measures to ensure safety. He said it's especially hard to see pets that succumb to smoke inhalation, whether it's a hamster or a dog.
Jeff is also the crossing guard at Bangert Elementary School, a job he's proudly carried out for just over a month. There are only five days a month he can't be there, but every other school day he's there every morning and afternoon, regardless of the hours he worked the night before. Even after working nightshifts, he makes sure he's at the school in time to give out high fives and get the children safely to school. He then goes home, goes to bed and is up to do it all over again by two o'clock that afternoon.
"There's one little girl that has to hug me every morning, and that just draws the heartstrings," he said with a smile. "I love interacting with the kids. When we do fire prevention at the school, I get to line everything up. To see the kids get excited when they see the firetrucks just warms the heart. They had a reading night a few weeks ago, and I cooked 300 hot dogs for them."
Jeff's wife of five years has worked at Bangert for over 20 years, and between them, they have four children and four grandchildren. Jeff pointed out how special it was that some of the children his wife taught are now alongside him as members of the fire department.
Another of Jeff's strong passions is animal advocacy. He owns two cats and two rescue dogs, one with three legs. "It hasn't slowed him down a bit," he said. "He's a 75-pound loveable lapdog."
He and his wife have been active supporters of the local animal shelters. They frequently load up their vehicles with cat litter and cat food and deliver it to shelters so that the abundance of abandoned felines have sufficient care. After a local dog was recently found hanging by her neck from a chain-link fence, Craven Animal Hospital requested help with the medical bills. Jeff didn't hesitate to take action.
"I gave them $1,000 toward the medical care," he said. "And I'm not a rich man, but I will give all I can give. That went straight to Craven Animal for the doctor bill, and then they were asking people to give gift cards for the Craven County Sheriff's Animal Control. I gave them two $100 gift cards for that, and I've currently got a Facebook fundraiser going to raise more. My goal is to raise $1,000 for them. There's a lot of animals out there that are not taken care of."
Animal Control rescues abused or abandoned animals, investigates the mistreatment of pets and seizes ones considered dangerous. Jeff hopes that when they run into similar situations, they can get the animal to the vet to receive medical care and provide necessities such as bedding and food. Jeff is doing his best to get the word out and encourage Craven County citizens to be proactive by spaying or neutering pets and taking steps to end animal abuse and neglect.
"We are their voice," he said with tears in his eyes. "If you're not going to take care of a pet, don't get it. It's a responsibility like a child. And if you get it and can't handle it, don't abuse it. There are people out there who will take care of it. I'm a true lover of animals. I just wish more people would take care of them."
Jeff's commitment to his community is something for which he doesn't want to be recognized. Instead, he would prefer people's energy go into following his example and doing what they can to help others, whether it's citizens with fire prevention needs, children who need to get to school safely or furry friends in need of a medical procedure or warm bed.
"I could go on for days about animals and fire service," said Jeff. "Just remember: an ounce of prevention is worth a lot, not only with fire service, but also with animals. Consider them."
Do you know somebody who should be featured in 52 Faces of Community? Visit https://www.newbernsj.com/52faces and click on the "Submit a Face" button.


● Where in the World is Aperture? an interview with Aperture's exhibitions manager, Annette Booth.
Every issue of the Aperture Photography App is free: select articles later appear here on the Aperture Blog. Click here to download the app today!
Love it? Bookmark this page.


These statistics are generated based on the current listing's property type and located in Huntington Hills. Average values are derived using median calculations.
2 freezers in the basement, 2 satellite dishes, TV in the living room and island in the basement kitchen.
Meet this unique 5-level split located on the massive corner lot.
Unconventional open beam ceiling adds beauty and architectural interest to the space.
This is the living room with a hardwood floor and gas fireplace.
This is the living room, looking straight into the staicase leading to the upper floor. Off the right is the dining room.
This is a closer look at the dining room. The door in the back leads to the kitchen.
This is the view from the dining room towards the living room.
The massive breakfast nook has a direct access to the deck.
This is a view from the breakfast nook towards the kitchen.
The kitchen is located in the back of the house with the view of the backyard.
This is a master bedroom.
This is a full bathroom ustairs.
This is a large family room located on the lower level. It features a second gas fireplace.
The family room on the lower level.
This is the utility room located in the basement. Off the right is the second of the two storage rooms.
This is a second kitchen in the basement looking straight ahead into the huge storage room.
Huge storage room in the basement.
Back of the house with a practical RV parking.
This is a view from the vegatable patch towards the greenhouse and the storage shed.
This is a vegetable patch on the side of lot.


Commissioner of Police Allen Whylie has been seen to be dragging his feet on investigating the allegations within the Auditor General's Report. He recently stated that he would wait on instructions from the Director of Public Prosecutions and the conclusion of the Senate Inquiry, even though he conceded that he doesn't have to. But according to the Commissioner, there will be an investigation because what he has seen is 'grave' and has left him annoyed.


text:
The Walking Dead – Thank You
Posted by Thom Yee in Television
Horror, Walking Dead, Zombies
The Walking Dead images courtesy of AMC.
6×03: "Thank You"
I don't think it takes that much thought to reach the conclusion that being eaten alive until you die (and obviously we're talking about being eaten in pieces, not just swallowed whole) probably isn't a great way to go. A lot of people died this week on The Walking Dead… not as many as last week, but a little more personally… and a lot less quickly. Obviously we've seen people bitten, eviscerated, and dismembered by walkers before on this show, but with how detailed these onscreen deaths are becoming as the show's effects budget increases alongside its ratings, it's getting tough to sit through these prolonged death scenes and not think about the value of mercy killing. When you're in a situation where almost all of you made it to the other side of the fence, don't just watch the one unlucky member of your group that didn't make it die. Shoot him in the head or something, he's being eaten alive! That's gotta hurt!
Right now a lot of you are probably feeling a bit like I did a few years ago after reading a particularly climactic issue of The Walking Dead comicbook. The Walking Dead is a show that, by its nature, courts death at any and every moment, and quite often those deaths are expected and often even funny. For much of this week's "Thank You", that was very much the case as most of the Alexandrians who were brave and stupid enough to follow Rick's lead met their ends in the most stilted and cliché fashion possible. As soon as any one of them expressed doubt or fear or even a small measure of resolve or bravery, they were cut down almost immediately.
That's what you get for bad-mouthing Rick!
But then, at least for a show like The Walking Dead, the unthinkable happened. Glenn, one of the longest surviving members of our group, one of the most beloved, one of the most important and enduring people on this show, is dead. For now, let's leave all of the theories around the character's potential survival to the side, no matter how attractive, convincing, and numerous they may be, and admit that to ourselves. Last week, back behind the Safe-Zone walls, it felt like so many Alexandrians were dropping like flies at the hands of the Wolves that of course our heroes were going to be safe and there to save the day, and I think a lot of us let that bit of false positivity creep its way into this week's viewing when we assumed that all of our principal characters were safe. It's been a long time since a truly core member of the cast died, and other than Daryl, Carl or Rick himself, they don't get any more core than Glenn.
That's what you get for slowing Rick down!
Judging by the online fan reactions I've seen, Glenn's death has met with an almost overwhelming sense of sadness, and I think it's a sadness that's greater for him than it would be for any other on the show. When Dale died, it was unexpected because it was one of the first major breaks from the comicbook, but he was really starting to get annoying and most viewers didn't mind seeing him go. The same could be said for Shane or Lori or Andrea, in fact most of us were cheering when we saw them die, but Glenn was different. He was decent and good and unthreatening by nature, but hopeful and useful and resourceful, and he grew with the show as we grew with the show. In some ways he was our viewpoint character, in many ways he was the type of person we would hope to be if we were in the same type of situation. He was our rock, not because he was the toughest or the leader of the group, but because we needed his caring and heart to carry us through a show that can be very grim and dark and unsympathetic, and now it's hard to know what to do without him.
That's what you get for defending people who bad-mouthed Rick!
There's a hushed, somber tone that's fallen over this Walking Dead group as we speak about Glenn. Truly it's a rare thing to care so much about a fictional character, especially in a popular television show, and that's something special and something that shouldn't be taken for granted. We may not feel good about Glenn's death, we may be grasping at every straw we can to deny it, but these feelings are a testament to how good this show is getting lately and how important story can be to our collective and individual psyches. As a comicbook reader, I've been prepared for Glenn's death for a while (and I don't think that's too much of a Walking Dead comicbook spoiler since I'm not saying exactly when or how he died there), but for me, especially with the different circumstances of his death in the comic, rather than sadness, I was overcome with feelings of anger at the time of reading the book. I think Glenn's comicbook death is the most angry and most emotional I've ever felt about a fictional character dying, and it wasn't anger at the creators or publishers, it was exactly the right type of anger, the anger I was supposed to feel about such a death and an extreme anger at the person responsible (a character who may still show up later on the show).
That's what you get for messing with Rick's friends!
Unfortunately, on the show the writers didn't do as good a job in building up Nicholas, whose suicide, though sensible and in line with everything I wrote at the beginning of this review, also led to Glenn's untimely demise, leaving Nicholas, no matter his redemptive final arc, as little more than a character for everybody to hate. This shallow hatred, in addition to where we are in terms of plot and place in the season, and a lot of behind-the-scenes speculation, has led people to believe Glenn's still alive. Would they really kill a major character at this odd early point and not the mid-season or full-season finale? How will Maggie help Deanna overcome the death of her husband (and son Aiden, don't forget) if she's reeling from her own husband's death (and rest of her family, don't forget)? And it doesn't really feel right that Glenn's own good nature in giving Nicholas another chance should prove to be his undoing. Maybe for a more arrogant character, maybe for a more foolish character, but not Glenn. What kind of a lesson is that for us to learn?
That's what you get for… being a friend of… Rick…?
What this episode definitely does is reaffirm the danger that the walkers still represent, even with the continuing threat that the Wolves might represent and even with the internal strife percolating inside the Alexandria walls. Maybe even more importantly, the events of "Thank You" are starting to show us that the writers may be willing to circumvent our own expectations of safety, storytelling convention, and even story expectations and buildup in order to bring us a show that's finally going to be daring and dangerous. For me, it didn't take long into season six for The Walking Dead to retake the crown of the better zombie show from Fear the Walking Dead as the show seems to have reached a real breaking point for Rick and co., one where core concepts and themes don't matter as much as the reality of this situation. I mean, who even cares about Rick vs. Morgan anymore, who's still thinking about the Wolves as a serious threat? In that final scene where Rick's in the RV being attacked by the Wolves, it didn't even matter that they were there, it was beside the point that Rick spent almost no effort killing five or six of them, all that mattered is that no matter how hard our heroes try and how big their individual victories can occasionally be, it's all downhill no matter what.
The Walking Dead — "Thank You" final score
Items of Note
If the walkers don't get you, Michonne, Heath, and guy shot in the leg (who's married to Sasha in real life), that swampy water will. It certainly can't be good to get that water into a bullet wound.
Also a lot of talk about Rick's cut left hand this episode. Don't know if that's going anywhere.
Next week's episode has an extra-length, ninety-minute running time, so get ready for at least six more minutes of commercials.
<< Last Episode: JSS
Next Episode: Here's Not Here >>
Fear the Walking Dead reviews
Shaun of the Dead review


There are an ever-growing number of online tools and resources related to digital storyingtelling.
This week, your task is to check out and experiment with some of these. Remember to Diigo anything you find potentially useful.
Booksie Young Adult Section http://www.booksie.com/young_adult Example: A different Twilight and a different Bella 40,000+ plus short stories, novels, and essays written and published by users. Other users can comment on stories (which usually includes very authentic teenage language.
Post some kind of storytelling object on your blog.
Check your Feedly for new posts from classmates and others.


text:
Эдмунд Лоу (; полное имя Эдмунд Дантес Лоу; 3 марта 1890, Сан-Хосе — 21 апреля 1971, Лос-Анджелес) — американский актёр кино.

За свою актёрскую карьеру, которая продолжалась с 1915 по 1960 год снялся в 124 фильмах, в том числе в 40 немых. После этого прекратил сниматься, появившись лишь в нескольких эпизодических ролях, играя самого себя (камео). С 1949 по 1957 годы работал также на телевидении. С 1917 по 1945 год выступил в 20 бродвейских спектаклях. Его вклад в искусство кино и телевидения отмечен звездой на Голливудской аллее славы.

Был женат вторым браком на актрисе Лилиан Тэшман с 1925 по 1934 год, когда актриса умерла.

Избранная фильмография
 1923 — Бесшумная команда / The Silent Command
 1926 — Сибирь / Siberia
 1928 — В старой Аризоне / In Old Arizona
 1930 — Песня мошенника
 1933 — Обед в восемь / Dinner at Eight
 1937 — Каждый день праздник/Every day's a Holiday
 1937 — Диллинджер / Dillinger
 1956 — Вокруг света за 80 дней / Around The World In 80 Days

Примечания

Ссылки

Голливудская «Аллея славы»
Похороненные на кладбище Сан-Фернандо-Мишн
Выпускники Университета Санта-Клары

redpajama_set_name: RedPajamaWikipedia


Again, these must be actual directories, not symlinks, and be sure to set the permissions appropriately. To eliminate the possibility of any naming mishap, you can grant READ access only on /.../data, and WRITE access only on /..../log, to the user creating the external tables.
Where external tables really shine are in the ease with which you can load their data into your tables. A particularly nice feature is that you can use any valid function that the current Oracle user has rights on to transform the raw data before loading it into your database tables. For example, suppose you had a function, get_bday_from_ssn (ssn in varchar2) that looked up an employee's birth date given their SSN. You can use that function to populate a BIRTH_DATE column in your local database table in the same step as you load the data into it.
Oracle 10g lets you create a new external table from data in your database, which goes into a flat file pushed from the database using the ORACLE_DATAPUMP access driver. This flat file is in an Oracle-proprietary format that can be read by DataPump. The syntax is similar to the CREATE TABLE... ORGANIZATION EXTERNAL above, but simpler -- since you can't specify the data format, you can specify very few access_parameters. The key difference is that you must specify the access driver, ORACLE_DATAPUMP, since the access driver defaults to ORACLE_LOADER.
We've seen an introduction to loading and unloading data with external tables. External tables in 9i and 10g provide a convenient, seamless way to move data in and out of the database, integrating SQL*Loader and Data Pump functionality with the power, scriptability and ease of SQL statements. It's definitely worth considering external tables the next time you have a daily upload or download to arrange.
Natalka Roshak is a senior Oracle and Sybase database administrator, analyst, and architect. She is based in Kingston, Ontario and consults across North America. More of her scripts and tips can be found in her online DBA toolkit at http://toolkit.rdbms-insight.com/.
Permalink Submitted by Jim Lu (not verified) on Tue, 2006-03-28 10:02.
This is the best summary of external table I have ever read. It is simple and clear. It really helped me understanding the ETL concept. Thank you very much for doing this.
Permalink Submitted by Kevin Closson (not verified) on Wed, 2006-06-07 15:10.
In 2002, PolyServe and XIOtech partnered to perform a huge Proof of Concept (audited by IDC) of a 10TB database on a 10 node cluster and ramped the active OLTP users count to 10,000 users. The project was called The Tens.
The entire setup was stored in PolyServe Matrix Server CFS, to include External Tables. With RAC, External Tables can be accessed via IPQO (Intra-node Parallel Query). The source data for the load was pipe-delimited and instered with APPEND as select /*+ PARALLEL */ * from External_table.
Permalink Submitted by Arun (not verified) on Thu, 2006-08-10 07:28.
Thanks a lot for this wonderful explanation.
It's so easy and efficient.
Permalink Submitted by Maria Antony (not verified) on Thu, 2006-08-24 09:43.
I always like the manuals that are 'Clear Cut' and easy to understand for all level of people. I could see that in your paper.
Permalink Submitted by Prasad (not verified) on Sat, 2006-09-16 21:04.
The most structured Oracle article I have ever seen - each line answered the next question that popped up in my mind.
Permalink Submitted by Guy Conan (not verified) on Wed, 2006-11-15 20:57.
I'm now working on a project where I have to deal with data transfert between different databases on different systems using Oracle and this Great explanation saved me hours!
Permalink Submitted by amardeep.sidhu on Thu, 2007-12-27 10:41.
Really greate but i need help.
Permalink Submitted by bandarna on Mon, 2008-03-17 02:19.
I used above example and finally got error. can any one help me?
4. Issued grant read and write privileges to directory object to Scott.
6. I have error when i issue select command.
Permalink Submitted by meuser on Tue, 2008-03-18 15:44.
Permalink Submitted by debrucer on Wed, 2008-03-26 19:46.
This is definitely something I needed to know about since I have been asked to complete a task that this will be perfect for :) Thank you! Thank you!
Petty perhaps, when you've had something spoon fed to you like this; but, it would be a nice touch when articles with SQL examples gave you a shot without the SQL> Prompt so you could cut and paste the entire code. As it was, I had to do 18 individual lines (okay, 16, I didn't cut and past the parenthesis).
Maybe a link to "download code" or something like that would be the solution.
At any rate, did I say "thanks"?
Permalink Submitted by singh.neerajin on Mon, 2008-04-28 01:19.
Is there any kind of similar thing we can use with XML file. Presently I am using the XSLT to transform the data into text file & then loading it to database through CONTROL file using SQL loader. Is there any way we cna directly fetch the XML file to database.
Permalink Submitted by jluziano on Thu, 2008-06-12 14:40.
I created a External table with 3 fileds, but in some register the last filed is empty, then this register is BAD.
How can I do to the third register to be OK.
Permalink Submitted by renu4dwh on Thu, 2008-07-03 06:29.
Permalink Submitted by hrivera99 on Thu, 2008-08-28 11:31.
Just a correction. You stated on: "Unloading data into an external file..."
"Oracle 10g lets you create a new external table from data in your database, which goes into a flat file "
It actually doesn't go to a flat file, but to a binary proprietary format file which is seen, from an OEL4.5 OS perspective, as a "PDP-11 UNIX/RT ldp" file type.
Permalink Submitted by barrywalkors on Sat, 2008-09-06 19:24.
Permalink Submitted by Daniel Saltman on Thu, 2008-12-18 18:03.
Permalink Submitted by yelluh on Sat, 2011-06-11 11:07.
Use the 'missing field values are null' fields-clause.
Permalink Submitted by navkrish on Wed, 2009-04-01 00:03.
What if my column has comma (,) as one of the character in it?
Watch for "Simpson,A" in Row 2.
In this case the column gets broke as Simpson and A. I want it to be together in Column 2.
Permalink Submitted by navkrish on Wed, 2009-04-01 00:43.
Permalink Submitted by wakula on Thu, 2009-04-16 08:31.
This is a very nice article. Thanks Natalka.
However the data security is an issue - if only Oracle has access to the .csv file then all the users having access to the database have access to this file. Or am I missing something?
Permalink Submitted by hsherif on Tue, 2009-11-10 13:41.
I am new to Oracle external tables and I found this article very illumnating in a short and concise manner. Thank you indeed!
Permalink Submitted by shadab on Wed, 2010-04-28 07:34.
Can I use CREATE or REPLACE EXTERNAL_TABLE ...?
so that the previous data file is replaced by the new one.
Could anybody tell me how do to delete the files created so as to free the space.
Permalink Submitted by soagra on Mon, 2010-07-12 08:05.
How can I handle tab separated values.
I'm also finding difficulty in converting formats (char to number , char to date) while putting data in external table.
Permalink Submitted by udaikiran_g on Wed, 2010-09-08 04:35.
In order to handle tab separated values while reading data from the file use FIELDS TERMINATED BY 0X'09' (zeroX'zero9').
How to dump data from multiple files?
Permalink Submitted by vineetarora3 on Tue, 2011-03-15 03:22.
Am new to external table concept but got an idea from your well written article.
Is it possible to add more columns to empl_info table apart from those present in the csv file?
Also, I would like to know the best way to dump data from multiple xls/csv files into oracle data tables? This dumping might be done daily as content of files will change. So shall we have multiple external tables for this?